'database/ORACLE'에 해당되는 글 93건

  1. 2015.10.26 [SQL]동명이인뽑아내기

[SQL]동명이인뽑아내기

database/ORACLE 2015. 10. 26. 21:58
반응형

동명이인뽑아내기

 

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

반응형
Posted by 공간사랑
,

티스토리툴바