IBM
C2090-610 · Question #13
Which SQL statement should be used to select the minimum and maximum salaries (SALARY), by job code (JOB), from a table EMPLOYEE?
The correct answer is A. SELECT job, MIN(salary), MAX(salary). See the full explanation below for the reasoning.
Question
Which SQL statement should be used to select the minimum and maximum salaries (SALARY), by job code (JOB), from a table EMPLOYEE?
Options
- ASELECT job, MIN(salary), MAX(salary)
- BSELECT job, MIN(salary), MAX(salary)
- CSELECT job, MIN(salary), MAX(salary)
- DSELECT JOB, MIN(salary), MAX(salary)
How the community answered
(27 responses)- A74% (20)
- B15% (4)
- C7% (2)
- D4% (1)
Community Discussion
No community discussion yet for this question.