[SQL]동명이인뽑아내기

동명이인뽑아내기

 

SELECT USER_NAME
FROM MEMBER
WHERE USER_NAME IN
(
 SELECT USER_NAME
 FROM MEMBER
 GROUP BY USER_NAME
 HAVING COUNT(USER_NAME) > 1
)