> > >

Oracle SQL 9i MCQs

Examine the data in the EMPLOYEES table given below:

LAST_NAME DEPARTMENT_ID SALARY

ALLEN 10 3000

MILLER 20 1500

King 20 2200

Davis 30 5000

Which of the following Subqueries work?

SELECT * FROM employees where salary > (SELECT MIN(salary) FROM employees GROUP BY department_id);

SELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department_id);

SELECT distinct department_id FROM employees Where salary > ANY (SELECT AVG(salary) FROM employees GROUP BY department_id);

SELECT department_id FROM employees WHERE SALARY > ALL (SELECT AVG(salary) FROM employees GROUP BY department_id);

SELECT department_id FROM employees WHERE salary > ALL (SELECT AVG(salary) FROM employees GROUP BY AVG(SALARY));

Answer

Correct Answer: SELECT department_id FROM employees WHERE SALARY > ALL (SELECT AVG(salary) FROM employees GROUP BY department_id);

Explanation:

Note: This Question is unanswered, help us to find answer for this one

Oracle SQL 9i Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it