To join within that table is called self join.
Example to check Duplicate Records:
select empid from employee where empid not in(select empid from employee group by empid having count(*)>1)
select empid a ,empname b from emp a, emp b
where a.empid=b.empid
Regards
sriram.R