1.

Which of the following query/queries return the employee ID and name of employees whose salary is greater than the salary of all employees in department number 20 of university. Order result by employee ID (refer table structures given above).(A)SELECT EID, NAMEFROM EMPLOYEEWHERE SALARY > (SELECT SALARY FROM EMPLOYEE WHERE DEPTNO=20) ORDER BY EID:(B)SELECT EID, NAMEFROM EMPLOYEEWHERE SALARY > (SELECT SALARY FROM EMPLOYEE WHERE DEPTNO=20);(C)SELECT EID, NAMEFROM EMPLOYEEWHERE SALARY > ALL(SELECT SALARY FROM EMPLOYEE WHERE DEPTNO=20)ORDER BY EIDChoose the correct answer from the options given below:

A. (A) and (B) only
B. (A) and (C) only
C. (B) only
D. (C) only
Answer» E.


Discussion

No Comment Found