Employee and Department Query

[sriram.bethe]

How to retrieve department no that is not having the data in emp table

Display all employees who are joined before their manager and they are not managers

[krishnaindia2007]

how to retrieve department no that is not having the data in emp table display all employees who are joined before their manager and they are not managers

select deptno , dname
from dept
where deptno not in (select deptno from emp);

select a.empno,a.ename, a.hiredate from emp a
where a.job <> 'manager'
and a.hiredate < (select hiredate from emp b where a.mgr = b.empno);