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 votes120 views1 answer
Drop all database tables oracle sql developer
SQL
1 vote193 views1 answer
Adding a check statement in sql
SQL
1 vote117 views2 answers
String to date postgres
SQL
3 votes121 views2 answers
Update Query in SQL Server
SQL
5 votes119 views2 answers
Get number of columns sql
SQL
2 votes167 views1 answer
Get the mysql table columns data type mysql
SQL
9 votes120 views4 answers
How to create new user and database postgresql in ubuntu
SQL
0 vote134 views2 answers
Sql 2 way of select unique
SQL
1 vote115 views1 answer
How to between in sql
SQL
0 vote265 views2 answers
Create fulltext index mysql
SQL