Deleting duplicate record in SQL Server

by

You need to reference the CTE in the delete statement…

WITH a as
(
SELECT Firstname,ROW_NUMBER() OVER(PARTITION by Firstname, empID ORDER BY Firstname) 
AS duplicateRecCount
FROM dbo.tblEmployee
)
--Now Delete Duplicate Records
DELETE FROM a
WHERE duplicateRecCount > 1

More Related Contents:

  1. sql server convert date to string MM/DD/YYYY
  2. Optional multi-valued parameters in SSRS
  3. Java: Finding duplicate in array [closed]
  4. Duplicate number and it value in column EXCEL [closed]
  5. How can I remove duplicate rows?
  6. Drop all duplicate rows across multiple columns in Python Pandas
  7. How to prevent duplicate usernames when people register?
  8. Remove pandas rows with duplicate indices
  9. Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. The statement has been terminated
  10. Algorithm: efficient way to remove duplicate integers from an array
  11. JQuery: Remove duplicate elements?
  12. Filter/Remove rows where column value is found more than once in a multidimensional array
  13. Select query to remove non-numeric characters
  14. Fastest way to remove duplicate documents in mongodb
  15. Group duplicate column IDs in pandas dataframe
  16. Find duplicate lines in a file and count how many time each line was duplicated?
  17. Partition Function COUNT() OVER possible using DISTINCT
  18. Prevent auto increment on MySQL duplicate insert
  19. Error: java.util.zip.ZipException: duplicate entry
  20. Deleting duplicate rows from a table
  21. Connecting to MS SQL Server with Windows Authentication using Python?
  22. Finding duplicate values in arraylist
  23. Find all duplicate documents in a MongoDB collection by a key field
  24. A connection was successfully established with the server, but then an error occurred during the login process. (Error Number: 233)
  25. Remove duplicate items from an array [duplicate]
  26. Delete duplicate rows in two columns simultaneously [duplicate]
  27. Detect when multiple enum items map to same value
  28. Using IF ELSE statement based on Count to execute different Insert statements
  29. Convert from DateTime to INT
  30. Check for duplicates before inserting

Leave a Comment