Loading

how to remove duplicates values in the table

how to remove duplicates values in the table

Durgaprasad Boddapati

Durgaprasad Boddapati

4y949SQL Server

the table contains primary key but table values have duplicate how to remove duplicates

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Anoop Kumar Sharma4y ago
Accepted answer
Hi,

I have already written a detailed article on "Delete duplicate records from table using CTE in SQL Server Database" which you can refer using below link:
https://codingbash.com/blog/delete-duplicate-records-from-table-using-cte-in-sql-server

I hope this wll help you.
+2
Jaydeep Patil4y ago
Hi,

Check the below URL and try to use as per your table details that work in your case

https://www.sqlservertutorial.net/sql-server-basics/delete-duplicates-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;
+2
Durgaprasad Boddapati4y ago
thank you anoopkumar i am excpted that answer
+3
Vishal Yelve4y ago
1. Example: I have taken Employee table
4. WITH EmployeesCTE AS
5. (
6. SELECT *, ROW_NUMBER()OVER(PARTITION BY ID ORDER BY ID) AS RowNumber
7. FROM Employees
8. )
9. DELETE FROM EmployeesCTE WHERE RowNumber > 1
+2

Amit Mohanty

Amit Mohanty4y ago

Hey, check the below links

https://www.c-sharpcorner.com/article/different-ways-to-find-and-delete-duplicate-rows-from-a-table-in-sql-server/

https://www.sqlservertutorial.net/sql-server-basics/delete-duplicates-sql-server/

+2