You look for matching keys that a different rows, for example
select *
from emp e1, emp e2
where e1.empno = e2.empno
and e1.rowid != e2.rowid
but generally you're better off using an analytic function eg
select *
from
( select e.*, count(*) over ( partition by empno ) as c
from emp e
)
where c > 1