/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

1 vote100 views2 answers
Mysql join two tables
SQL
0 vote91 views1 answer
Database springboot
SQL
0 vote98 views1 answer
Sql select rows between 1000 and 2000
SQL
2 votes160 views1 answer
Mysql create user with remote access
SQL
37 votes102 views3 answers
Postgresql insert column
SQL
0 vote92 views2 answers
Raise notice in postgresql function
SQL
0 vote97 views1 answer
Sql declare variable single line
SQL
1 vote93 views1 answer
Oracle finding duplicate records
SQL
0 vote108 views1 answer
Mysql grant user wildcard database
SQL
1 vote91 views1 answer
Mysql size int
SQL