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