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) > 1
Archétype Informatique SARL web design, 12 place Balmigère, 11200 Camplong d'Aude, Aude, France. Tél. (France) 04 68 43 52 38