How to delete duplicate rows

By j Miracle

How you can delete duplicate rows from sql server.

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

How to delete duplicate rows (934 Views)