Find Duplicate SQL records (with count output) SELECT word, COUNT(*) AS acount FROM Words GROUP BY word HAVING ( COUNT(word) > 1 )