PrepAway - Latest Free Exam Questions & Answers

Which SQL statement should be used to retrieve the minimum and maximum salaries (SALARY) for each job code (JO

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?

PrepAway - Latest Free Exam Questions & Answers

A.
SELECT job, MIN(salary), MAX(salary) FROM employee GROUP BY job ORDER BY
job;

B.
SELECT job, MIN(salary), MAX(salary) FROM employee ORDER BY job;

C.
SELECT job, MIN(salary), MAX(salary) FROM employee GROUP BY SALARY ORDER
BY job;

D.
SELECT job, MIN(salary), MAX(salary) FROM employee GROUP BY MIN(salary),
MAX(salary) ORDER BY job;


Leave a Reply