SQL ile tekrar eden kayıtları bulmak

SELECT id, name, count( * ) AS again
FROM tablename
GROUP BY name 
HAVING again >1
ORDER BY name ASC