Delete duplicate rows

WITH CTE AS(
   SELECT [col1], [col2], [col3], [col4], [col5], [col6], [col7],
       RN = ROW_NUMBER()OVER(PARTITION BY col1 ORDER BY col1)
   FROM dbo.Table1
)
DELETE FROM CTE WHERE RN > 1

Source: stackoverflow.com

Similar codes

10 votes151 views4 answers
Join multiple tables in sql
SQL
1 vote137 views1 answer
Oracle list datafiles in tablespace
SQL
0 vote166 views2 answers
How to login to mysql as normal user in ubuntu
SQL
-1 vote137 views1 answer
How to open blade file from blade in laravel
SQL
1 vote143 views1 answer
Moodle query first user access
SQL
1 vote140 views1 answer
Load sql into mamp
SQL
0 vote131 views1 answer
Sql make sure every user is unqiuew
SQL
12 votes146 views6 answers
Select distinct
SQL
1 vote131 views1 answer
How to find median of a column sql
SQL
27 votes155 views6 answers
Set password mysql
SQL