Comprehension: Consider the following table structures related to a university for given questions.
EMPLOYEE
|
NAME |
VARCHAR (30) |
NOT NULL, |
|
EID |
VARCHAR (10) |
NOT NULL, |
|
DEPTNO |
INT (5) |
NOT NULL, |
|
HODEID |
VARCHAR (10), |
|
|
SALARY |
INT (10), |
|
PRIMARY KEY (EID),
FOREIGN KEY (HODEID) REFRENCES EMPLOYEE (EID),
FOREIGN KEY (DEPTNO) REFRENCES DEPARTMENT (DID);
DEPARTMENT
|
DID |
INT (5) |
NOT NULL, |
|
DNAME |
VARCHAR (30) |
NOT NULL, |
|
HODID |
VARCHAR (10) |
NOT NULL, |
|
HODNAME |
VARCHAR (30), |
|
PRIMARY KEY (DID),
UNIQUE (DNAME),
FOREIGN KEY (HODID) REFERENCES EMPLOYEE (EID),
PROJECT WORE:
|
EMPID |
VARCHAR (10) |
NOT NULL, |
|
PROJNO |
INT (5) |
NOT NULL, |
|
PROJECTLOC |
VARCHAR (30) |
NOT NULL, |
PRIMARY KEY (EMPID, PROJNQ),
FOREIGN KEY (EMPID) REFERENCES EMPLOYEE (EID),
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, NAME
FROM EMPLOYEE
WHERE SALARY > (SELECT SALARY FROM EMPLOYEE WHERE DEPTNO=20) ORDER BY EID:
(B)
SELECT EID, NAME
FROM EMPLOYEE
WHERE SALARY > (SELECT SALARY FROM EMPLOYEE WHERE DEPTNO=20);
(C)
SELECT EID, NAME
FROM EMPLOYEE
WHERE SALARY > ALL(SELECT SALARY FROM EMPLOYEE WHERE DEPTNO=20)
ORDER BY EID
Choose the correct answer from the options given below:
