Database-Management-System
August 29, 2024Database-Management-System
August 29, 2024Database-Management-System
| Question 716 |
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);
UNIQUE. The SQL statement
SELECT COUNT(*) FROM Employee WHERE SALARY > ANY (SELECT SALARY FROM EMPLOYEE);
| 10 | |
| 9 | |
| 5 | |
| 0 |
Question 716 Explanation:
This query counts the number of employees who get more than the minimum salary. From the 10 employees, you need to exclude all those employees who are getting the minimum salary. Since the SALARY column is UNIQUE, only one employee will be getting the minimum salary.
Correct Answer: B
Question 716 Explanation:
This query counts the number of employees who get more than the minimum salary. From the 10 employees, you need to exclude all those employees who are getting the minimum salary. Since the SALARY column is UNIQUE, only one employee will be getting the minimum salary.