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

0 vote234 views1 answer
Describe in sqlite3
SQL
0 vote228 views2 answers
Spring properties file for db
SQL
1 vote257 views1 answer
Mysql select another database
SQL
1 vote260 views1 answer
Query for all indexes in table postgres
SQL
5 votes253 views2 answers
Oracle rename table
SQL
0 vote274 views1 answer
Datatables server side filter where clause
SQL
0 vote260 views1 answer
Postgresql remove new line from string
SQL
33 votes258 views2 answers
Postgres how to add field created at
SQL
0 vote214 views1 answer
Now() -1 mysql
SQL
0 vote255 views1 answer
Pl sql constraint user function
SQL