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 employeeWHERE salary < 100000
B. SELECT salary FROM employeeWHERE salary > 100000
C. SELECT salary FROM employeeWHERE salary > 100,000.00
D. SELECT * FROM employeeWHERE salary GREATER THAN 100000
|
Download Printable PDF. VALID exam to help you PASS. |
 |