Free C2090-616 Web TestEngine Demo

Q10 Single choice

Consider the following SQL statement:

SELECT workdept, empno, lastname, salary,

RANK() OVER (PARTITION BY workdept ORDER BY salary) AS rank_salary

FROM employee

ORDER BY workdept, lastname

What does the RANK() OVER (PARTITION BY workdept ORDER BY salary) clause do?

A
It ranks the rows in each WORKDEPT by SALARY.
B
It groups all rows by WORKDEPT, then ranks all rows in the complete result set by SALARY.
C
It generates a blank output line after each group of rows with the same WORKDEPT, and ranks these groups by SALARY.
D
It tells the optimizer to physically partition the EMPLOYEE table by the WORKDEPT column for runtime execution, and ranks each WORKDEPT by SALARY.

C2090-616 Web TestEngine demo