3:07 AM
Unknown
SELECT with a GROUP BY clause. Let's say name is the column you want to find duplicates in:SELECT firstname, lastname , COUNT(*) c FROM civilservant GROUP BY firstname, lastname HAVING c > 1;
3:07 AM
Unknown
MYSQL
Do a
SELECT firstname, lastname , COUNT(*) c FROM civilservant GROUP BY firstname, lastname HAVING c > 1;
SELECT firstname, lastname , COUNT(*) c FROM civilservant GROUP BY firstname, lastname HAVING c > 1;