PrepAway - Latest Free Exam Questions & Answers

Which SQL statement would be used to retrieve only salaries that are greater than $100,000.00 from a table nam

Which SQL statement would be used to retrieve only salaries that are greater than
$100,000.00 from a table named EMPLOYEE?

PrepAway - Latest Free Exam Questions & Answers

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:


Leave a Reply