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

14 votes282 views1 answer
Excel is not a database
SQL
2 votes296 views1 answer
Sql OR
SQL
0 vote269 views1 answer
Oracle execute immediate quotes
SQL
0 vote285 views1 answer
Psql datestyle
SQL
0 vote288 views1 answer
Rename view mysql
SQL
6 votes312 views3 answers
How to delete table sqlite
SQL
0 vote282 views2 answers
How to find sql server agent jobs related to a database
SQL
0 vote291 views1 answer
Ms sql database data size
SQL
0 vote273 views1 answer
Java input type sql date
SQL
32 votes312 views6 answers
Insert select
SQL