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 vote151 views3 answers
Insert query in ci
SQL
0 vote97 views1 answer
Mariadb list tables
SQL
13 votes274 views4 answers
Sql joining 3 tables
SQL
8 votes127 views1 answer
Today minus 15 days postgresql
SQL
13 votes127 views4 answers
What is sql
SQL
0 vote132 views1 answer
Xampp increame mysql speed
SQL
0 vote130 views1 answer
Postgres float to int
SQL
0 vote135 views1 answer
Flush user resource mysql
SQL
0 vote139 views1 answer
Avoid duplicate in one to many relationship join in sql
SQL
1 vote146 views1 answer
Create table variable in sql stored procedure
SQL