Database Errors Question:
Download Job Interview Questions and Answers 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
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? |