Display list of jobs, number of employees of each job from departments 10 and 20. List only records if number of employees in each jobs are more than 1.

DURGAPRASAD

• Jul 23rd, 2012

SELECT JOB,COUNT(EMPNO) AS NOOFEMP FROM SCOTT.EMP WHERE DEPTNO IN (10,20)
GROUP BY JOB HAVING COUNT(EMPNO) > 1

Answer Question  Select Best Answer