Delete duplicate rows

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

Source: stackoverflow.com

Similar codes

-1 vote165 views3 answers
How to restart mysql in linux
SQL
14 votes152 views1 answer
Excel
SQL
1 vote215 views2 answers
Job for mysql.service failed because the control process exited with error code. see "systemctl status mysql.service" and "journalctl -xe" for details.
SQL
0 vote167 views1 answer
Oracle string length
SQL
0 vote153 views1 answer
Pl sql disable trigger
SQL
0 vote181 views1 answer
Mysql update column default value CURRENT_TIMESTAMP error
SQL
0 vote167 views1 answer
Sql show founctions
SQL
1 vote150 views1 answer
Found option without preceding group in config file: /etc/mysql/mariadb.conf.d/50-server.cnf at line: 1
SQL
0 vote155 views1 answer
Set a value by excuting stored procedure
SQL
0 vote193 views1 answer
Sql get table last modified time
SQL