count(*)over() improve query speed? code example
Example: select count postgres double row count > 1
SELECT
firstname,
lastname,
count(*)
FROM people
GROUP BY
firstname,
lastname
HAVING count(*) > 1;
SELECT
firstname,
lastname,
count(*)
FROM people
GROUP BY
firstname,
lastname
HAVING count(*) > 1;