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