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

2 votes235 views1 answer
11:04:35 PM [mysql] Error: MySQL shutdown unexpectedly. 11:04:35 PM [mysql] This may be due to a blocked port, missing dependencies,
SQL
8 votes195 views1 answer
Similarities between ddl and dml
SQL
5 votes276 views3 answers
Sql limit offset
SQL
0 vote243 views1 answer
Sql server user permissions and roles
SQL
3 votes241 views1 answer
Oracle APEX elapsed time
SQL
28 votes239 views4 answers
Show tables mysql
SQL
6 votes224 views3 answers
Mysql server is not starting xampp
SQL
4 votes219 views1 answer
To date oracle with time
SQL
1 vote269 views1 answer
Insert many to many sql
SQL
2 votes240 views1 answer
Columns Present in a table
SQL