[sql]select e.* from emp e where not exists (select a.* from emp a where a.emp_supervisor_no=e.emp_no);
[/sql]
May be?