Question: Select Distinct will leave duplicates out.  Need a commmand to find duplicate in a column? 

Answer: SELECT email,\nCOUNT(email) AS NumOccurrences\nFROM users\nGROUP BY email\nHAVING ( COUNT(email) > 1 )
This question from the Yahoo Q&A forum is categorized in the topic: Entertainment & Music