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

5 votes307 views2 answers
Mysql create database charset utf8mb4
SQL
1 vote281 views1 answer
Not exists mysql
SQL
4 votes307 views2 answers
Sql offset
SQL
0 vote367 views1 answer
How to check foreign key constraint in sql
SQL
2 votes281 views2 answers
Join update query in sql
SQL
1 vote309 views1 answer
Round function in sql oracle
SQL
0 vote381 views1 answer
How to show current database in mysql
SQL
2 votes301 views1 answer
Mysql change data type of column
SQL
7 votes273 views2 answers
Create index mysql
SQL
3 votes311 views1 answer
Query less than datetime sql
SQL