Delete dublicate rows sql

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

Similar codes

0 vote126 views1 answer
Oracle list chain steps
SQL
1 vote137 views1 answer
Select if then postgresql
SQL
1 vote129 views1 answer
Select dba users oracle
SQL
0 vote145 views1 answer
Trigger vérifier stock
SQL
0 vote148 views1 answer
Sql stored procedure update if parameter is not null
SQL
3 votes140 views2 answers
Mysql config user password
SQL
-1 vote144 views2 answers
Postgresql get last 10 records
SQL
-1 vote150 views1 answer
Add bool column in sql
SQL
0 vote148 views1 answer
Mysql change timestamp on update
SQL
0 vote198 views3 answers
How to find all role in mysql
SQL