1z0-071 Exam Dumps | Examine the description of the ENPLYEES table: (Exhibit) Which two queries return all rows for employees

<< Prev Question Next Question >>

Examine the description of the ENPLYEES table:

Which two queries return all rows for employees whose salary is greater than the average salary in their department?

A. SELECT "
FROM employees
WHERE salary > ANY
SELECT AVG (salary)
EROM employees
GROUP BY department_ id);

B. SELECT
FROM employees
WHERE salary > AVG (salary) OVER (PARTITION BY department _ id);

C. SELECT"
FROM employees e1
WHERE salary >!
SELECT AVG (salary)
FROM employees e2
WHERE e1. Department _id = e2, department_ id

D. SELECT.
FROM
SELECT e.", AVG (salary) OVER (PARTITION BY department id) avg_ sal
FROM employees e
WHERE salary > avg_ sal;

E. SELECT"
FROM employees
WHERE salary >
( SELECT AVG
(salary) FROM
employees

Download PDF File