SQL:List the employees who are managers

select * from emp where empno in (select distinct(mgr) from emp);