In “Chapter 2: Using OLAP > Ranking Functions > Ranking examples”, ranking example 1 should be:
SELECT Surname, Sex, Salary, RANK() OVER ( ORDER BY Salary DESC) as RANK FROM Employees WHERE State IN ('CA') AND DepartmentID =200 ORDER BY Salary DESC;
The results from the above query:
Surname Sex Salary RANK ------- --- ------ ---- Savarino F 72300.000 1 Clark F 45000.000 2 Overbey M 39300.000 3
In “Chapter 2: Using OLAP > Ranking Functions > Ranking examples”, ranking example 2 should be:
SELECT Surname, Sex, Salary, RANK() OVER (PARTITION BY Sex ORDER BY Salary DESC) AS RANK FROM Employees WHERE State IN ('CA', 'AZ') AND DepartmentID IN (200, 300) ORDER BY Sex, Salary DESC;
The results from the above query:
Surname Sex Salary RANK ------- --- --------- ---- Savarino F 72300.000 1 Jordan F 51432.000 2 Clark F 45000.000 3 Coleman M 42300.000 1 Overbey M 39300.000 2