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 vote111 views1 answer
Check if database exists sql
SQL
12 votes96 views4 answers
SQL Where
SQL
7 votes110 views3 answers
Select latest entry in sql table
SQL
3 votes109 views1 answer
Sql case update
SQL
3 votes107 views2 answers
Oracle for loop
SQL
0 vote114 views2 answers
Athena drop partition
SQL
0 vote143 views1 answer
Cahnge column name apex oracle
SQL
0 vote101 views2 answers
Homebrew nysql launch
SQL
0 vote107 views2 answers
Demmarrer un service mysql teminal cmd
SQL
0 vote104 views1 answer
Mysql command line ubuntu
SQL