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.

Asked by: mishel | Member Since Feb-2012 | Asked on: Feb 23rd, 2012

View all questions by mishel

Return back to Oracle

Answer Question

Showing Answers 1 - 1 of 1 Answers

DURGAPRASAD

Answered On : 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

User Panel

Lost Password

Get Activation Code

Interview Coaching

How to Overcome Employment Gap during interview.

Do you have any questions that you want to ask?

Has anyone asked you for help? What did you do?

Do you like working in a team or alone? Explain.

Describe a time when you had to convince a friend ?

How productive are you?

What will you do when you are not able to get your message across to your audience?

Tell me about a skill you recently acquired or improved.

How do you approach a problem?

What do you do when things do not go as planned? Cite an example.

Connect

Question Categories

Oracle DBA FAQ

Interview Question

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.

Oracle Program

Give your answer:

Related Answered Questions

Related Open Questions