/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 vote293 views1 answer
Cannot insert duplicate key in object 'dbo.Instructor'. The duplicate key value is (2).
SQL
0 vote268 views1 answer
How to see the content of tables in pgadmin
SQL
0 vote289 views1 answer
Sql view index
SQL
16 votes347 views3 answers
T-SQL Add Column
SQL
0 vote314 views1 answer
Migrations.RunSQL
SQL
0 vote340 views2 answers
Coursera spark sql max count
SQL
12 votes308 views4 answers
Mysql get date difference in hours
SQL
7 votes293 views2 answers
Sql server drop temp table if exists
SQL
2 votes297 views2 answers
Checking data type in sql server
SQL
1 vote295 views1 answer
Mysql count words
SQL