[MySQL] 중복된 데이터 검색하기

SELECT * FROM TEST_USER B WHERE name 
IN (SELECT B.name FROM (SELECT MAX(A.name) AS name 
FROM TEST_USER A GROUP BY A.name HAVING COUNT(A.name) > 1) B);