WITH Pre AS(
SELECT
    EMP_CODE,
    EMP_FIRST_NAME,
    EMP_LAST_NAME,
    REPLACE(EMP_FIRST_NAME,' ','') AS REPLACE_FIRST_NAME,
    REPLACE(EMP_LAST_NAME,' ','') AS REPLACE_LAST_NAME
FROM
    EMP
WHERE
    VALID_FLG = '1'
)
SELECT
    EMP_CODE AS CODE,
    EMP_LAST_NAME AS SURNAME,
    EMP_FIRST_NAME AS NAME
FROM
    Pre
WHERE (REPLACE_FIRST_NAME||REPLACE_LAST_NAME) IN
    (
    SELECT
        (REPLACE_FIRST_NAME||REPLACE_LAST_NAME) AS renketsu
    FROM
        Pre 
    group by
        renketsu
    HAVING COUNT(renketsu) >= 2
    )
ORDER BY
    (REPLACE_LAST_NAME||REPLACE_FIRST_NAME) ASC,
    CODE ASC