-- GROUP BYとHAVINGを使用して重複レコードを抽出
SELECT
    EMP_LAST_NAME AND EMP_FIRST_NAME,
    COUNT(EMP_LAST_NAME AND EMP_FIRST_NAME)
FROM
    EMP
GROUP BY
    EMP
HAVING
    COUNT(EMP_LAST_NAME AND EMP_FIRST_NAME) > 1
    
    
EMP_LAST_NAME(REPLACE ,' ','') ASC,EMP_FIRST_NAME(REPLACE ,' ','') ASC,EMP_CODE ASC


EMP_CODE AS CODE
EMP_LAST_NAME AS SURNAME
EMP_FIRST_NAME AS NAME;