Showing posts with label avoid duplicates. Show all posts
Showing posts with label avoid duplicates. Show all posts
Friday, July 20, 2012
Insert into without duplicates
INSERT INTO TableDuplicates
(empId)
SELECT empId
FROM TableEmployees
WHERE empId NOT IN (select empId from TableDuplicates)
Subscribe to:
Posts (Atom)