select EMP_CODE CODE,
replace(EMP_LAST_NAME, ' ', '') SURNAME,
replace(EMP_FIRST_NAME,' ', '' ) NAME

from EMP

where VALID_FLG = '1'
and(EMP_LAST_NAME,EMP_FIRST_NAME) in(
		SELECT
			EMP_LAST_NAME,EMP_FIRST_NAME FROM EMP
		WHERE
			EMP_LAST_NAME = EMP.EMP_LAST_NAME
			AND EMP_FIRST_NAME = EMP.EMP_FIRST_NAME
		GROUP BY
			EMP_LAST_NAME,EMP_FIRST_NAME 
		HAVING
			count(*) > 1)
			
order by SURNAME,
CODE