FROM table_name
GROUP BY col_1 HAVING dupcnt > 1
Thursday, September 10, 2009
Finding the Duplicate records from the Table
SELECT MAX(col_1) AS dupid,COUNT(col_1) AS dupcnt
FROM table_name
GROUP BY col_1 HAVING dupcnt > 1
FROM table_name
GROUP BY col_1 HAVING dupcnt > 1
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment