Database Errors Question: Download Database Errors PDF
Display details of employees who are senior to there own manager?
Answer:
select e.ename,e.hiredate,m.ename,m.hiredate from emp e,emp m
where e.mgr=m.empno
and e.hiredate<m.hiredate
where e.mgr=m.empno
and e.hiredate<m.hiredate
| Previous Question | Next Question |
| How to resolve the sqlcode -501 error in db2? | How to Select 38th row details in table without using rownum? |