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 vote165 views1 answer
Check constraint to check if date greater than todays date
SQL
0 vote164 views1 answer
How to select all fieldsin a soql query
SQL
0 vote165 views1 answer
Sql count null values in all columns
SQL
0 vote166 views2 answers
How to delete the rows with null values in mysql
SQL
0 vote163 views1 answer
How to fix mysql stop unexpectedly
SQL
1 vote151 views1 answer
Mysql login console
SQL
4 votes163 views1 answer
What are the data types in sql
SQL
5 votes279 views2 answers
Mysql date greater than 30 days
SQL
0 vote180 views1 answer
Postgresql import a database of gzip
SQL
0 vote183 views2 answers
SQLSTATE[HY000]: General error: 3780 Referencing column 'role_id' and referenced column 'id' in foreign key constraint 'user_role_id foreign' are incompatible.
SQL