select count postgres double row count > 1
SELECT
firstname,
lastname,
count(*)
FROM people
GROUP BY
firstname,
lastname
HAVING count(*) > 1;
Are there any code examples left?
New code examples in category SQL
SELECT
firstname,
lastname,
count(*)
FROM people
GROUP BY
firstname,
lastname
HAVING count(*) > 1;