IBM
C2090-610 · Question #112
Which SQL statement would be used to retrieve only salaries that are greater than $100,000.00 from a table named EMPLOYEE?
The correct answer is B. SELECT salary FROM employee. See the full explanation below for the reasoning.
Question
Which SQL statement would be used to retrieve only salaries that are greater than $100,000.00 from a table named EMPLOYEE?
Options
- ASELECT * FROM employee
- BSELECT salary FROM employee
- CSELECT salary FROM employee
- DSELECT * FROM employee
How the community answered
(20 responses)- A10% (2)
- B70% (14)
- C15% (3)
- D5% (1)
Community Discussion
No community discussion yet for this question.