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 vote329 views1 answer
Mysql dump everythign
SQL
1 vote338 views1 answer
Oracle update with sequence
SQL
0 vote337 views1 answer
Mariadb errno 121
SQL
0 vote361 views1 answer
Left join vs inner join performance
SQL
0 vote377 views1 answer
Update mysql from paypal shopping cart and ipn
SQL
3 votes316 views3 answers
Stop mysql service ubuntu
SQL
0 vote338 views1 answer
Convert int to varchar sql
SQL
0 vote315 views1 answer
Install ms sql server management studio
SQL
0 vote406 views2 answers
SQL SERVER ORDER BY DATE NULL LAST
SQL
1 vote349 views1 answer
Wherein mysql
SQL