Which SQL statement would be used to retrieve only salaries that are greater than $100,000.00
from a table named EMPLOYEE?
A.
SELECT * FROM employee
WHERE salary < 100000
B.
SELECT salary FROM employee
WHERE salary > 100000
C.
SELECT salary FROM employee
WHERE salary > 100,000.00
D.
SELECT * FROM employee
WHERE salary GREATER THAN 100000
Explanation: