Home Forums SQL Server 2005 T-SQL (SS2K5) delete duplicates RE: delete duplicates
rcassis-1001343
Valued Member
Points: 56
More actions
January 27, 2010 at 5:10 pm
#1109670
Here is a CTE based solution....
; WITH EmployeesCTE
AS
(
SELECT ROW_NUMBER() OVER( PARTITION BY EmpID, EmpName ORDER BY EmpID ) AS RowNumber,
EmpID, EmpName
FROM Employees
)
DELETE
FROM EmployeesCTE
WHERE RowNumber != 1
--Ramesh
This is elegant...