Database Errors Interview Question:

Display details of employees who are senior to there own manager?

Submitted by: Administrator

select e.ename,e.hiredate,m.ename,m.hiredate from emp e,emp m
where e.mgr=m.empno
and e.hiredate<m.hiredate
Submitted by: Administrator