SQL找出重复的记录只显示一条记录

SELECT id, name
FROM a
WHERE id IN (SELECT MIN(id) FROM a GROUP BY name HAVING COUNT(*) > 1)