Support HAVING of GROUP BY

[the42]

Title has it. Don't know of another easy way to search for duplicates in a column. Sure

SELECT col, count(col)
FROM a
GROUP BY col
ORDER BY 2 desc
LIMIT 100

works somehow, but requires fiddling with LIMIT.

[cube2222]

Hey @the42, HAVING should be added at some point.

For the time being you can also use subqueries / common table expressions.

SELECT * FROM (SELECT col, COUNT(*) as howmany FROM a GROUP BY col) q WHERE q.howmany > 1

WITH
    valcounts AS (SELECT col, COUNT(*) as howmany FROM a GROUP BY col)
SELECT * FROM valcounts WHERE howmany > 1