Database Errors Question: Download Database Errors PDF

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

Tweet Share WhatsApp

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

Download Database Errors PDF Read All 20 Database Errors Questions
Previous QuestionNext Question
How to resolve the sqlcode -501 error in db2?How to Select 38th row details in table without using rownum?