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

0 vote258 views1 answer
Get duplicate entry sql
SQL
6 votes329 views3 answers
Check if string contains substring sql
SQL
11 votes267 views1 answer
How to get ddl for materialized view
SQL
0 vote323 views1 answer
Kimball data warehouse sql calendar
SQL
0 vote287 views1 answer
Sql update subtract value
SQL
0 vote313 views1 answer
Mysql order by rand limit 1 really slow
SQL
1 vote275 views1 answer
Get the User Name and Domain Name from an Email Address
SQL
2 votes302 views3 answers
Install mysql workbench ubuntu 20.04 terminal
SQL
1 vote277 views1 answer
Update and replace mysql
SQL
2 votes288 views1 answer
Could not find driver (SQL: select * from information_schema.tables where table_schema = francis_koopmart and table_name = migrations and table_type = 'BASE TABLE')
SQL