Hinding duplicate records

[Anon]

Hi Guys

Can you tell me is there a quick way of finding duplicate records in a Db.

I dont want to return the complete set of records then perform a query on each result to see if it is duplicated.

Thanks in advance

Justin

[Anon]

OOPs

Should have said Finding not Hinding!

Justin

[Anon]

try:

SELECT DISTINCT * FROM tableName

[Anon]

SELECT count(*) as duplicates ,field
FROM table
GROUP BY field
ORDER BY duplicates desc;

this will give you a list of records and a count of how many times any value of "field" has been found.

[Anon]

I Think I will use

SELECT FROM tablename
GROUP BY group1, group2, group3
HAVING COUNT() >1

Thanks

Justin