Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
INSERT INTO names (last, first, dob, ...) ... ; INSERT INTO name_dup1 (last, first, dob) SELECT last, first, dob FROM names GROUP BY last, first, dob HAVING count(*) > 1; DELETE FROM names WHERE (last, first, dob) not in (SELECT last, first, dob FROM name_dup1);
DELETE FROM names t0 WHERE not exists (SELECT 1 FROM name_dup1 t1 WHERE t0.last = t1.last AND t0.first = t1.first AND t0.dob = t1.dob);
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.