SELECT emp_id
FROM (SELECT emp_id, emp_family_cd
, RANK() OVER(PARTITION BY emp_id ORDER BY emp_family_cd) rn
, COUNT(*) OVER(PARTITION BY emp_id) cnt
FROM emp_family_tbl
WHERE emp_id <> :asEmp_id
)
WHERE (emp_family_cd, rn, cnt)
IN (SELECT emp_family_cd
, RANK() OVER(ORDER BY emp_family_cd) rn
, COUNT(*) OVER() cnt
FROM emp_family_tbl
WHERE emp_id = :asEmp_id
)
GROUP BY emp_id, cnt
HAVING COUNT(*) = cnt