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 vote198 views1 answer
Sql server remove primary key without dropping table
SQL
3 votes153 views1 answer
Oracle list invalid password ORA-01017
SQL
1 vote168 views1 answer
How to see which columns are indexxed mysql
SQL
0 vote154 views1 answer
List in one column mysql
SQL
4 votes146 views1 answer
Fetch first 10 rows in oracle sql developer
SQL
32 votes188 views6 answers
Rename column mysql
SQL
0 vote156 views1 answer
Select row from mysql where date more than 30 days
SQL
0 vote159 views1 answer
Oracle sql how to overcome 999 limit for IN
SQL
9 votes143 views2 answers
Get first 3 letters in sql
SQL
0 vote142 views1 answer
How to Remove milliseconds from Date time
SQL