View the Exhibit and examine the structure of the EMPLOYEES table.
You want to know the FIRST_NAME and SALARY for all employees who have the same manager as that of the employee with the first name ‘Neena’ and have salary equal to or greater than that of’Neena’.
Which SQL statement would give you the desired result?
A. SELECTfirst_name, salary FROM employeesWHERE (manager_id, salary) >= ALL (SELECT manager_id, salary FROM employees WHERE first_name = ‘Neena’ AND first_name <> ‘Neena’;
B. SELECT first_name, salary FROM employeesWHERE (manager_id, salary) >= (SELECT manager_id, salaryFROM employeesWHERE first_name = ‘Neena’)AND first_name <> ‘Neena’;
C. SELECT first_name, salary FROM employeesWHERE (manager_id, salary) >= ANY (SELECT manager_id, salary FROM employees WHERE first_name = ‘Neena’ AND first_name <> ‘Neena’;
D. SELECT first_name, salary FROM employeesWHERE (manager_id = (SELECT manager_idFROM employeesWHERE first_name = ‘Neena’)AND salary >= (SELECT salaryFROM employeesWHERE first_name = ‘Neena’))AND first name <>
‘Neena’;
|
Download Printable PDF. VALID exam to help you PASS. |
 |