Answers for "sql query to get duplicate records in table based on one column and remove duplicated values"

SQL
5

sql server delete records that have a single duplicate column

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;
Posted by: Guest on March-12-2020

Code answers related to "sql query to get duplicate records in table based on one column and remove duplicated values"

Code answers related to "SQL"

Browse Popular Code Answers by Language