Posts Tagged duplicate table entries

Find duplicate entry in table

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(*) […]

, ,