IBM
C2090-610 · Question #113
C2090-610 Question #113: Real Exam Question with Answer & Explanation
Sign in or unlock C2090-610 to reveal the answer and full explanation for question #113. The question stem and answer options stay visible for context.
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)
Unlock C2090-610 to see the answer
You've previewed enough free C2090-610 questions. Unlock C2090-610 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.