Oracle Program

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.

Questions by mishel

Showing Answers 1 - 1 of 1 Answers

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

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions