Archétype Informatique SARL web design, 12 place Balmigère, 11200 Camplong d'Aude, Aude, France. Tél. (France) 04 68 43 52 38
Monthly Archives: April 2008
SQL query to find duplicate rows
This is one of those things I can never remember how to do when I need to do it. I don’t know why, it’s really quite simple: SELECT emailaddress, firstname, lastname, COUNT(emailaddress) FROM customers GROUP BY emailaddress HAVING COUNT(emailaddress) > … Continue reading