Which SQL statement will retrieve the department number (WORKDEPT) and the highest salary (SALARY) for each department in a table named EMPLOYEE and arrange the result set in ascending order by department?

Question

Accepted Answer

B. SELECT workdept, MAX(salary)

Answer

A. SELECT workdept, salary

Answer

C. SELECT workdept, MAX(salary)

Answer

D. SELECT workdept, MAX(salary)

Which SQL statement will retrieve the department number (WORKDEPT) and the highest salary (SALARY) for each department in a table named EMPLOYEE and arrange the result set in ascending order by…

Question

Options

How the community answered

Explanation

Topics

Community Discussion