PDA

View Full Version : Sql

robert123
04-10-02, 11:52
Let me know the answer?
Examine the structure of the EMPLOYEES table:
EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) DEPARTMENT_ID NUMBER SALARY NUMBER
What is the correct syntax for an inline view?

A.
SELECT a.last_name, a.salary, a.department_id, b.maxsalFROM employees a, (SELECT department_id, max(salary)maxsal FROM employees GROUP BY department_id) bWHERE a.department_id = b.department_id AND a.salary < b.maxsal;

B.
SELECT a.last_name, a.salary, a.department_idFROM employees a WHERE a.department_id IN (SELECT department_id FROM employees b GROUP BY department_id having salary = (SELECT max(salary) from employees c));

C.
SELECT a.last_name, a.salary, a.department_idFROM employees a WHERE a.salary = (SELECT max(salary) FROM employees b WHERE a.department_id = b.department_id);

D.
SELECT a.last_name, a.salary, a.department_idFROM employees a WHERE (a.department_id, a.salary) IN (SELECT department_id max(salary) FROM employees b GROUP BY department_id ORDER BY department_id);