Search This Blog

Tuesday, March 13, 2012

Find duplicate rows in a table


SELECT col_1, col_2, count(col_2)
FROM table_1
GROUP BY col_2
HAVING count(col_2) > 1
Posted by at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)