sql-parser
sql-parser copied to clipboard
`HAVING` clause is not supported without `GROUP BY`
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;