Tuesday, August 10, 2010

SQL:List the employees who are managers

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

No comments:

Post a Comment