This is a very handy query all the db programmers and db admins need everyday.
Lets say, we have a table “test” with 2 fields “id” and “name”.
We need to find out which names are duplicated in the table. So here is the query:
select name, count(*) from test group by name having count(*) > 1;
This will [...]