Delete duplicate rows

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

Source: stackoverflow.com

Similar codes

1 vote128 views1 answer
Simple project for database
SQL
-1 vote132 views1 answer
Count occurrences sql
SQL
11 votes126 views1 answer
Sql query to find duplicates in column
SQL
0 vote136 views1 answer
Sql query to get column names and data types in sql server
SQL
2 votes123 views2 answers
Sqlalchemy filter or
SQL
0 vote127 views4 answers
Sql server date format yyyy-mm-dd
SQL
0 vote160 views2 answers
CREATE OR REPLACE FUNCTION
SQL
1 vote127 views2 answers
Mysql update LAST_INSERT_ID()
SQL
3 votes152 views2 answers
Oracle sql first day of month
SQL
2 votes122 views1 answer
Q operator in plsql
SQL