[ORACLE] 중복카운트수 찾기, 대소문자 구별
·
Database
SELECT UPPER(MEMBER_ID),COUNT(UPPER(MEMBER_ID)) FROM MEMBER_INFO GROUP BY UPPER(MEMBER_ID) HAVING COUNT(UPPER(MEMBER_ID)) > 1