IBM
C2090-610 · Question #113
Which SQL statement should be used to retrieve the minimum and maximum salaries (SALARY) for each job code (JOB), sorted by job code, from a table named 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 retrieve the minimum and maximum salaries (SALARY) for each job code (JOB), sorted by job code, from a table named 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
(28 responses)- A82% (23)
- B4% (1)
- C11% (3)
- D4% (1)
Community Discussion
No community discussion yet for this question.