SELECT col_1, col_2, count(col_2)
FROM table_1
GROUP BY col_2
HAVING count(col_2) > 1
Showing posts with label Find duplicate rows in a table. Show all posts
Showing posts with label Find duplicate rows in a table. Show all posts
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
Subscribe to:
Posts (Atom)