Monthly Archives: April 2008

SQL query to find duplicate rows

Posted on 15 April, 2008 by Veronica Yuill

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 →

Posted in Databases | Tagged , | Leave a comment