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 vote182 views2 answers
Connect to mysql server mac terminal
SQL
0 vote237 views1 answer
Mysql trigger to delete old data
SQL
16 votes243 views6 answers
Mysql find duplicates in same table
SQL
0 vote266 views1 answer
Python mysql check if database exists
SQL
0 vote179 views1 answer
18446744073709551615 mariadb left join order by
SQL
0 vote279 views1 answer
Bigrock database connection string
SQL
6 votes239 views2 answers
How to get yesterday date in mysql
SQL
0 vote208 views1 answer
Ubuntu stop mysql from starting on boot
SQL
0 vote183 views1 answer
One table with another
SQL
2 votes228 views1 answer
Mysql shell insert into
SQL