SELECT 
    EMP_CODE AS CODE
    ,EMP_LAST_NAME AS SURNAME
    ,EMP_FIRST_NAME AS NAME
FROM 
    EMP AS tbl_e
WHERE 
    VALID_FLG = '1' AND REPLACE(EMP_LAST_NAME || EMP_FIRST_NAME,' ','') IN 
(
SELECT
    REPLACE (EMP_LAST_NAME || EMP_FIRST_NAME,' ','') as '姓名'
FROM
    EMP
WHERE 
    VALID_FLG = '1'
GROUP BY
    REPLACE(EMP_LAST_NAME || EMP_FIRST_NAME,' ','')
HAVING
    COUNT(REPLACE(EMP_LAST_NAME || EMP_FIRST_NAME,' ','')) = 2
)
ORDER BY
    REPLACE(SURNAME || NAME,' ','')
    ,CODE;