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 > ALL (SELECT SALARY FROM EMPLOYEE);

Prints:

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

From the BB Assistant Programmer February 2023 – Written (BIBM) exam, question 18 of 37.

More from this paper