/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 vote215 views1 answer
Get date ISO in psql
SQL
0 vote213 views1 answer
Mysql change innodb to myisam
SQL
0 vote205 views1 answer
Load data from text file to mysql database on mac terminal
SQL
0 vote214 views1 answer
Mysql db dump restore max file size issue
SQL
0 vote196 views1 answer
How to output a different column name in mysql
SQL
1 vote208 views2 answers
How to check if sql query is correct online
SQL
-1 vote233 views2 answers
Sql search all tables for attributes
SQL
16 votes224 views3 answers
Update table from another table
SQL
-1 vote193 views1 answer
Search all tables all columns for a specific value in mssql-server
SQL
5 votes208 views1 answer
Sort order on two columns sql
SQL