IBM Exam C2090-616 Topic 3 Question 3 Discussion

Actual exam question for IBM's C2090-616 exam

Question #: 3
Topic #: 3

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?

AIt ranks the rows in each WORKDEPT by SALARY

BIt groups all rows by WORKDEPT, then ranks all rows in the complete result set by SALARY

CIt generates a blank output line after each group of rows with the same WORKDEPT, and ranks these groups by SALARY

DIt tells the optimizer to physically partition the EMPLOYEE table by the WORKDEPT column for runtime execution, and ranks each WORKDEPT by SALARY

Show Suggested Answer

Suggested Answer: B

by Andra at May 07, 2022, 10:02 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!