Delete dublicate rows sql

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

Similar codes

6 votes345 views1 answer
Postgresql get year
SQL
1 vote348 views1 answer
Sql list all procedures
SQL
0 vote370 views1 answer
List column names of multiple tables psql
SQL
1 vote358 views2 answers
Datetrunc hour snowflake
SQL
0 vote451 views1 answer
Compress sql file database ubuntu
SQL
0 vote360 views1 answer
Sql select merge multiple values
SQL
8 votes358 views4 answers
Mysql update one table from another table multiple columns
SQL
1 vote366 views1 answer
Sql pick random row
SQL
0 vote315 views2 answers
How to combine two sql queries in one result
SQL
0 vote362 views1 answer
Sql pad left 0
SQL