Friday, March 28, 2008

Find duplicate rows in table

If you need to find the duplicate rows in a database table you can use this query to do that. SELECT COL_01, COUNT(*) FROM TABLE group by COL_01 having count(*) > 1

No comments: