select
    EMP_CODE as CODE,
    EMP_LAST_NAME as SURNAME,
    EMP_FIRST_NAME as NAME
from
    emp
where
    replace(surname, " ", "") in(
    select
        replace(emp_last_name, " ", "") as sur
    from
        emp
    where
        valid_flg = 1
    group by
        sur
    having
        count(sur) > 1
    )
order by
    replace(surname, " ", "") asc,
    emp_code asc;