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 vote202 views1 answer
Mysql bash execute sql file
SQL
0 vote195 views1 answer
Sql server Cost Fifo query
SQL
0 vote188 views1 answer
PSQL qith variables
SQL
3 votes193 views1 answer
Mysql replace string in table
SQL
0 vote207 views1 answer
Sqlite woth cmake
SQL
0 vote186 views1 answer
How to reset AI in sql
SQL
1 vote191 views1 answer
Grab all records from one table to another oracle sql
SQL
0 vote203 views1 answer
Logtash mysql cofiguration file
SQL
0 vote183 views2 answers
Mysql create table if not exists
SQL
0 vote198 views1 answer
SQL Server date literal
SQL