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

8 votes321 views2 answers
Update sql server from another table
SQL
3 votes320 views3 answers
Illuminate database queryexception could not find driver (sql select * from
SQL
1 vote272 views1 answer
Add time to date sql
SQL
16 votes293 views4 answers
Find duplicates mysql
SQL
0 vote298 views1 answer
Raiserror with nowait
SQL
0 vote287 views1 answer
Connexion mysql
SQL
0 vote280 views1 answer
Casterar postgres
SQL
3 votes296 views2 answers
Sql paging query
SQL
0 vote287 views2 answers
Nested query
SQL
5 votes278 views1 answer
Oracle columns in all_tables
SQL