Sunday, January 9, 2011

How to delete duplicate rows

SELECT col1, col2, count(*)
FROM t1
GROUP BY col1, col2
HAVING count(*) > 1
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)