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.
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
Gravitation cannot be held responsible for people falling in love ~ Albert Einstein