Table Employee has 10 records. It has a non-NULL SALARY column which is also UNIQUE.The SQL statementSELECT COUNT(*) FROM Employee WHERE SALARY > ANY (SELECT SALARY FROM EMPLOYEE);prints
Table Employee has 10 records. It has a non-NULL SALARY column which is also UNIQUE.The SQL statementSELECT COUNT(*) FROM Employee WHERE SALARY > ANY (SELECT SALARY FROM EMPLOYEE);prints
A). 10
B). 9
C). 5
D). 0
1 answers
9
ANY compares a value with each of the values in a list or results from a query and evaluates to true if the result of an inner query contains at least one row. ANY must be preceded by comparison operators(=, >, <, <=, >=, <>).
Employee table has 10 records and each value in non-NULL SALARY column is unique i.e different. So, in that 10 records one of the record will be minimum which cannot be greater than any nine value of the salary column. Hence the condition
WHERE SALARY > ANY (SELECT SALARY FROM employee)
will be true nine times. So, the COUNT(*) outputs 9.
Other Questions
1. In LISP, which of the following function assigns the value 10 to the symbol a?
2. What is the first octet range for a class A IP address?
3. The first step of the implementation phase is
4. A proportional plus integral contro-ller can:
5. As the temperature increases, the current gain
7. The starting point for development of an MIS is;
8. A multiple-form file management system
10. Transmission of computerised data from one location to another is called