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
Vbscript clean up ADODB.Recordset
SQL
2 votes169 views2 answers
Set value to null sql
SQL
8 votes156 views2 answers
Default sql server port
SQL
0 vote118 views1 answer
Declarative base sqlalchemy
SQL
0 vote134 views1 answer
Nuget sqllite-net-pcl
SQL
2 votes114 views2 answers
Install sqlalchemy
SQL
2 votes108 views1 answer
Get first 2 letter in sql
SQL
4 votes129 views2 answers
What is table in sql
SQL
0 vote124 views2 answers
How to find max and min salary in sql
SQL
1 vote114 views1 answer
Convert rows to string sql server
SQL