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 GREATER THAN 100000
B.
SELECT salary FROM employee WHERE salary > 100,000.00
C.
SELECT salary FROM employee WHERE salary > 100000
D.
SELECT * FROM employee WHERE salary < 100000
Explanation: