Which SQL statement should be used to select the minimum and maximum salaries (SALARY), by job code (JOB), from a table EMPLOYEE?
A. SELECT job, MIN(salary), MAX(salary)FROM employeeGROUP BY job;
B. SELECT job, MIN(salary), MAX(salary)FROM employeeORDER BY job;
C. SELECT job, MIN(salary), MAX(salary)FROM employeeGROUP BY job, MIN(salary), MAX(salary);
D. SELECT JOB, MIN(salary), MAX(salary)FROM employeeORDER BY job, MIN(salary), MAX(salary);
|
Download Printable PDF. VALID exam to help you PASS. |
 |