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

1 vote124 views1 answer
Show table columns
SQL
2 votes120 views1 answer
Sql update alias
SQL
3 votes159 views2 answers
Oracle sql first day of month
SQL
1 vote134 views2 answers
How to install sql server management studio in ubuntu 18.04
SQL
2 votes175 views1 answer
Remove foreign key constraints in postgres
SQL
37 votes128 views3 answers
Postgresql insert column
SQL
51 votes227 views6 answers
Change column name sql
SQL
0 vote141 views1 answer
Mysql change innodb to myisam
SQL
3 votes129 views1 answer
Sql server version query
SQL
1 vote141 views1 answer
Mysql workbench in ubuntu 14.04
SQL