Friday, April 24, 2015

Duplicate rows in a table

SELECT
  Col1, Col2, COUNT(*)
FROM Table1
 GROUP BY Col1, Col2
HAVING COUNT(*) > 1
Posted by at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)