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

21 votes275 views6 answers
Change column in mysql
SQL
1 vote269 views1 answer
Sql how to duplicate a table
SQL
0 vote283 views1 answer
Show tables in cassandra cql
SQL
0 vote285 views1 answer
Mysql db dump restore max file size issue
SQL
0 vote309 views1 answer
Psql check if sql script is valid
SQL
3 votes259 views3 answers
Sql current year
SQL
0 vote276 views1 answer
Function plsql
SQL
0 vote208 views1 answer
How to get last client id sql
SQL
1 vote266 views1 answer
How to unlock table in mysql
SQL
0 vote261 views1 answer
Use where instead of join
SQL