sql-parser icon indicating copy to clipboard operation
sql-parser copied to clipboard

`HAVING` clause is not supported without `GROUP BY`

Open cdmh opened this issue 3 years ago • 0 comments

The parser reports a syntax error on a HAVING clause if there is no GROUP BY clause. Here's a valid example statement where the GROUP BY is implicit

SELECT COUNT(c_custkey) FROM customer HAVING COUNT(c_custkey) > 5;

cdmh avatar Aug 23 '21 16:08 cdmh