Câu 41: C2090-610: DB2 10.1 Fundamentals

Which SQL statement should be used to select the minimum and maximum salaries (SALARY), by job code (JOB), from a table EMPLOYEE?

1. A. SELECT job, MIN(salary), MAX(salary)FROM employeeGROUP BY job; — đáp án hiện tại
2. B. SELECT job, MIN(salary), MAX(salary)FROM employeeORDER BY job;
3. C. SELECT job, MIN(salary), MAX(salary)FROM employeeGROUP BY job, MIN(salary), MAX(salary);
4. D. SELECT JOB, MIN(salary), MAX(salary)FROM employeeORDER BY job, MIN(salary), MAX(salary);