Table Employee has 10 records. It has a non-NULL SALARY column which is also UNIQUE. The SQL statement SELECT COUNT(*) FROM Employee WHERE SALARY >…

Table Employee has 10 records. It has a non-NULL SALARY column which is also UNIQUE. The SQL statement

SELECT COUNT(*) FROM Employee WHERE SALARY > ANY (SELECT SALARY
FROM EMPLOYEE);

prints

  1. a) 0
  2. b) 5
  3. c) 9
  4. d) 10

From the Combined Bank Assistant Programmer (CSE) March 2021 – Preliminary exam, question 23 of 86.

More from this paper