WITH t as(

    SELECT
        EMP_CODE as CODE
        ,EMP_LAST_NAME as SURNAME
        ,EMP_FIRST_NAME as NAME
        ,trim(replace(EMP_LAST_NAME,' ','')) || trim(replace(EMP_FIRST_NAME,' ','')) as keyy
    FROM
        EMP
    WHERE
        VALID_FLG = '1'
), t2 as(
SELECT
    keyy
    ,count(1) as cnt
FROM
    t
group by keyy
)
SELECT
    t.CODE
    ,t.SURNAME
    ,t.NAME
FROM t
left join t2
on t.keyy = t2.keyy
where t2.cnt >= 2
order by
    t.keyy asc
    ,t.CODE asc