/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

-2 votes178 views3 answers
Sqlite reset autoincrement
SQL
1 vote166 views3 answers
Mysql disable foreign keys check
SQL
1 vote179 views1 answer
Write a query to create an empty table from an existing table?
SQL
0 vote158 views2 answers
Postgresql change user role grant
SQL
0 vote125 views1 answer
Delete all rows from table sqlite
SQL
1 vote171 views1 answer
OstgreSQL version
SQL
58 votes520 views6 answers
Create new user in postgres
SQL
14 votes191 views3 answers
Inner join sql oracle
SQL
23 votes164 views5 answers
Sql substring
SQL
3 votes172 views2 answers
Get current year sql
SQL