Answers

Question and Answer:

  Home  Database Errors

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

select e.ename,e.hiredate,m.ename,m.hiredate from emp e,emp m

where e.mgr=m.empno

and e.hiredate<m.hiredate

 139 views

More Questions for you: