Database Errors Question: Download Questions PDF
Display details of employees who are senior to there own manager?
![Database Errors Interview Answer Database Errors Interview Question](https://globalguideline.com/public/images/interview/35.png)
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
Download Database Errors Interview Questions And Answers
PDF
Previous Question | Next Question |
How to resolve the sqlcode -501 error in db2? | How to Select 38th row details in table without using rownum? |