/SQL/DELETE DUPLICATE VALUES FROM A TABLE IN SQL SERVER

DELETE DUPLICATE VALUES FROM A TABLE IN SQL SERVER

WITH cte AS (
    SELECT 
        contact_id, 
        first_name, 
        last_name, 
        email, 
        ROW_NUMBER() OVER (
            PARTITION BY 
                first_name, 
                last_name, 
                email
            ORDER BY 
                first_name, 
                last_name, 
                email
        ) row_num
     FROM 
        sales.contacts
)
DELETE FROM cte
WHERE row_num > 1;
Code language: SQL (Structured Query Language) (sql)

Source: sqlservertutorial.net

Similar codes

0 vote227 views1 answer
Compare strings lexicographically in sql
SQL
0 vote182 views1 answer
Sql server split string and insert into table select
SQL
2 votes173 views2 answers
Get all columns from table sql
SQL
0 vote190 views1 answer
Add column to table with default value plsql
SQL
13 votes204 views4 answers
Command line mysql import
SQL
2 votes189 views1 answer
Change primary key sql
SQL
0 vote191 views1 answer
SAP Return
SQL
4 votes197 views3 answers
How to describe a table in sqlite3
SQL
1 vote255 views1 answer
Postgres select as csv
SQL
0 vote205 views1 answer
#1231 - Variable 'sql_mode' can't be set to the value of 'NULL'
SQL