Microsoft Dot Net Master

Microsoft Dot Net Master
Microsoft Dot Net Master

Tuesday, August 9, 2011

Delete Duplicate Records In Sql Server

DELETE
FROM emp
WHERE empid NOT IN
(
SELECT  MAX(empid)
FROM emp
GROUP BY empname,sal,address)


No comments:

Post a Comment