Scenario: In a database with an Employees table containing columns EmployeeID, Name, Salary, and DepartmentID, which SQL query would use the RANK$()$ window function to retrieve the ranking of employees within each department based on their salary?

Context:

Employees Table Columns:

EmployeeID

Name

Salary

DepartmentID

A

SELECT EmployeeID, Name, Salary, DepartmentID,

RANK$()$ OVER $($PARTITION BY DepartmentID ORDER BY Salary DESC$)$ AS DepartmentRank

FROM Employees;

B

SELECT EmployeeID, Name, Salary, DepartmentID,

RANK$()$ OVER $($ORDER BY Salary DESC$)$ AS DepartmentRank

FROM Employees;

C

SELECT $*$ FROM Employees

ORDER BY RANK$()$ OVER $($PARTITION BY DepartmentID ORDER BY Salary DESC$)$;

D

SELECT EmployeeID, Name, Salary, DepartmentID,

RANK$()$ OVER $($PARTITION BY Salary ORDER BY DepartmentID$)$ AS DepartmentRank

FROM Employees;

Previous