SELECT EMP_CODE AS CODE, EMP_LAST_NAME AS SURNAME, EMP_FIRST_NAME AS NAME
FROM EMP
WHERE VALID_FLG = '1'
AND TRIM(EMP_LAST_NAME | EMP_FIRST_NAME)
IN (SELECT TRIM(EMP_LAST_NAME | EMP_FIRST_NAME) AS EMP_NAME
FROM EMP WHERE VALID_FLG = '1'
GROUP BY EMP_NAME HAVING COUNT(*) >= 2)
ORDER BY TRIM(SURNAME | NAME) ASC, CODE ASC