SELECT
EMP_CODE AS CODE,
REPLACE(EMP_LAST_NAME, ' ','') AS SURNAME,
REPLACE(EMP_FIRST_NAME, ' ','') AS NAME
FROM
EMP
WHERE
VALID_FLG ='1'
AND
(SELECT  REPLACE(EMP_LAST_NAME, ' ','')
FROM EMP) = (SELECT  REPLACE(EMP_LAST_NAME, ' ','')
FROM EMP)
AND
(SELECT  REPLACE(EMP_FIRST_NAME, ' ','')
FROM EMP) = (SELECT  REPLACE(EMP_FIRST_NAME, ' ','')
FROM EMP)
ORDER BY
SURNAME ASC,
CODE ASC
;