Finding duplicates

[Anand Loni]

Hi,

I want to find the duplicate records from the table. My table structure is : 1st column is auto generated number, second column is listname and third column is data. I want to find out the duplicates from table with same listname and data.

I am confused with this. Can anybody help me?

Regards,
Anand

[Shailesh Chandra]

try this query , It will fetch only those records from table where listname and data is being repeated. but this may not solve your problem completely because it will exclude those value which are not being repeated as part of group (LISTNAME, DATA)



SELECT LISTNAME, DATA, COUNT(*) FROM MY_TABLE GROOUP BY LISTNAME, DATA HAVING COUNT(*) > 1


Thanks,
Shailesh

[Muhammad Saifuddin]

Originally posted by Shailesh Chandra:
SELECT LISTNAME, DATA, COUNT(*) FROM MY_TABLE GROOUP BY LISTNAME, DATA HAVING COUNT(*) > 1

just post to make a little correction in query,
remove the extra the "O" in GROUP BY clause.