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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment