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

2 votes175 views1 answer
Oracle find unusable indexes
SQL
20 votes177 views4 answers
Reset auto increment in MySQL
SQL
1 vote207 views1 answer
Oracle columns table
SQL
0 vote183 views1 answer
Mysql grant grant option
SQL
0 vote178 views1 answer
Mysql date time string format python
SQL
0 vote197 views3 answers
Delete in SQL SERVER
SQL
0 vote188 views1 answer
MySql shutdown unexpectedly InnoDB: Mutexes and rw_locks use Windows interlocked functions InnoDB: Uses event mutexes
SQL
0 vote202 views1 answer
T sql dynamic top n query
SQL
0 vote209 views1 answer
Sql query inline if
SQL
0 vote184 views1 answer
Mysql shell ERROR: Not connected.
SQL