Note : You must have (Identity key) (EmpId) field in the table.
DELETE
FROM emp
WHERE empID NOT IN
(
SELECT MAX(empID)
FROM emp
GROUP BY empname)
Showing posts with label delete duplicate data from Table. Show all posts
Showing posts with label delete duplicate data from Table. Show all posts
Friday, March 12, 2010
Subscribe to:
Posts (Atom)