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

4 votes308 views2 answers
Mysql delete user if exists
SQL
0 vote316 views1 answer
Closure in sql
SQL
7 votes289 views1 answer
Forge server hosting
SQL
0 vote367 views1 answer
Oracle convert int to date
SQL
0 vote332 views1 answer
Joomla execute raw sql
SQL
0 vote341 views1 answer
Sql cursor example multiple columns
SQL
1 vote334 views1 answer
Nullif postgresql
SQL
0 vote514 views1 answer
Get first match in each group mysql query
SQL
3 votes302 views2 answers
How to modify rows in SQL Server
SQL
0 vote294 views2 answers
Find lowest number in sql
SQL