select 
    EMP_CODE as CODE,
    TRIM(EMP_LAST_NAME,'') as SURNAME,
    TRIM(EMP_FIRST_NAME,'') as NAME
    from EMP
    where VALID_FLG = '1'
    GROUP BY SURNAME
    HAVING COUNT(EMP_LAST_NAME) > 1
    order by SURNAME, CODE;