select
    EMP_CODE as CODE,
    EMP_LAST_NAME as SURNAME,
    EMP_FIRST_NAME as NAME
    
from
    (
    select
        replace(emp_last_name, " ", "") as surname,
        replace(emp_first_name, " ", "") as name,
        replace(emp_last_name, " ", "") || replace(emp_first_name, " ", "") as fullname
    from
        (
        select
            *
        from
            emp
        where
            valid_flg = 1
        )
    group by
        fullname
    having
        count(fullname) > 1
    ) as sur_cnt

inner join
    emp
on
    sur_cnt.surname = replace(emp.emp_last_name, " ", "")
and
    sur_cnt.name = replace(emp.emp_first_name, " ", "")
where
    valid_flg = 1
order by
    replace(emp.emp_last_name, " ", "") asc,
    replace(emp.emp_first_name, " ", "") asc,
    emp_code asc;