select * from EMP;

select EMP_CODE as CODE, EMP_LAST_NAME as SURNAME, EMP_FIRST_NAME as NAME from
(select EMP_CODE, replace(EMP_LAST_NAME, " ", "") as EMP_LAST_NAME
, replace(EMP_FIRST_NAME, " ", "") as EMP_FIRST_NAME from EMP where VALID_FLG = '1') as a
where exists(
select * from
(select EMP_CODE, replace(EMP_LAST_NAME, " ", "") as EMP_LAST_NAME
, replace(EMP_FIRST_NAME, " ", "") as EMP_FIRST_NAME from EMP as b where VALID_FLG = '1')
where a.CODE != b.CODE
)
order by SURNAME, CODE;