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

1 vote144 views1 answer
How to run sql script
SQL
10 votes154 views2 answers
Tsql merge example
SQL
0 vote150 views1 answer
Psql use query result convert Decimal python numpy psycopg2
SQL
0 vote160 views1 answer
Mysql shell set time_zone
SQL
4 votes153 views1 answer
Oracle error line
SQL
0 vote192 views1 answer
Set Mamp mysql globally
SQL
0 vote168 views1 answer
Enable sql server full text indexing
SQL
15 votes192 views5 answers
Show tables in oracle
SQL
0 vote164 views1 answer
Sql express database size limit
SQL
1 vote163 views1 answer
Wordpress change http to https phpmyadmin
SQL