/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 vote112 views1 answer
Sql datediff db2
SQL
1 vote111 views1 answer
Postgres convert date to string
SQL
0 vote111 views1 answer
Create table using the clause with as
SQL
32 votes110 views6 answers
Sql count where
SQL
0 vote110 views1 answer
List all functions and procedures in postgres query
SQL
8 votes134 views1 answer
My sql version
SQL
2 votes109 views1 answer
Sqlite show table indexes
SQL
1 vote115 views2 answers
Django.core.exceptions.ImproperlyConfigured: mysqlclient 1.4.0 or newer is required; you have 0.10.1.
SQL
0 vote111 views2 answers
Mysql get routine parameter list
SQL
0 vote121 views1 answer
System.Data.SqlClient.SqlException: 'Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.' SqlDataAdapter
SQL