SELECT
  CODE,
  SUBNAME,
  NAME
FROM
  (
    SELECT
      EMP_CODE AS 'CODE',
      EMP_LAST_NAME AS 'SUBNAME',
      EMP_FIRST_NAME AS 'NAME',
      REPLACE(EMP_LAST_NAME || EMP_FIRST_NAME, ' ', '') AS 'FULLNAME'
    FROM
      EMP
    /*GROUP BY
      FULLNAME
    HAVING
      COUNT(FULLNAME) > 1*/
    WHERE FULLNAME IN (FULLNAME)
  )
ORDER BY
  FULLNAME ASC,
  CODE ASC