Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select deptno from (select deptno,count(*) no_emp from emp
- group by deptno) test
- where test.no_emp=(select max(no_emp) from (select deptno,count(*) no_emp from emp
- group by deptno));
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement