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 vote366 views1 answer
Python sqlalchemy connection show server
SQL
5 votes314 views1 answer
Oracle sysdate
SQL
1 vote376 views1 answer
Sql server set variable if exists
SQL
0 vote316 views1 answer
Postgresql CREATE EXTENSION pgcrypto
SQL
1 vote307 views1 answer
How to see all table partition in oracle
SQL
0 vote281 views1 answer
Java spring boot connect to sql server
SQL
0 vote341 views1 answer
Execute sql stored procedure in powershell
SQL
0 vote337 views1 answer
Mariadb search columns
SQL
0 vote324 views1 answer
Mysql update set sum
SQL
1 vote315 views1 answer
How much every mysql database record takes from diskspace
SQL