The SQL Wizard

As a follow up to my last post, here is an extremely simple way to show each player's salary percentile ranking using Oracle...

A table named SALARIES contains the player's salaries:

FullName                       Salary
------------------------------ ---------------------
Crosby, Sidney                 8700000.00
Gonchar, Sergei                5000000.00
Fleury, Marc-Andre             5000000.00
Whitney, Ryan                  4000000.00
Malkin, Evgeni                 3834000.00
Orpik, Brooks                  3750000.00
Satan, Miroslav                3500000.00
Sykora, Petr                   2625000.00
Sydor, Darryl                  2500000.00
Fedotenko, Ruslan              2250000.00
Staal, Jordan                  2200000.00
Gill, Hal                      2075000.00
Eaton, Mark                    2000000.00
Dupuis, Pascal                 1400000.00
Cooke, Matt                    1200000.00
Goligoski, Alex                984000.00
Letang, Kris                   835000.00
Godard, Eric                   750000.00
Scuderi, Rob                   713000.00
Talbot, Maxime                 675000.00
Beech, Kris                    585000.00
Taffe, Jeff                    550000.00
Kennedy, Tyler                 542000.00
Sabourin, Dany                 512000.00
Minard, Chris                  500000.00

The following query will rank each salary...

SELECT FullName
    ,Salary
    ,ROUND(PERCENT_RANK() OVER(PARTITION BY NULL ORDER BY Salary), 2) * 100 Percentile
FROM SALARIES
ORDER BY Percentile DESC

...and the results are...

FullName                       Salary                Percentile
------------------------------ --------------------- -----------
Crosby, Sidney                 8700000.00            100
Gonchar, Sergei                5000000.00            92
Fleury, Marc-Andre             5000000.00            92
Whitney, Ryan                  4000000.00            88
Malkin, Evgeni                 3834000.00            83
Orpik, Brooks                  3750000.00            79
Satan, Miroslav                3500000.00            75
Sykora, Petr                   2625000.00            71
Sydor, Darryl                  2500000.00            67
Fedotenko, Ruslan              2250000.00            63
Staal, Jordan                  2200000.00            58
Gill, Hal                      2075000.00            54
Eaton, Mark                    2000000.00            50
Dupuis, Pascal                 1400000.00            46
Cooke, Matt                    1200000.00            42
Goligoski, Alex                984000.00             38
Letang, Kris                   835000.00             33
Godard, Eric                   750000.00             29
Scuderi, Rob                   713000.00             25
Talbot, Maxime                 675000.00             21
Beech, Kris                    585000.00             17
Taffe, Jeff                    550000.00             13
Kennedy, Tyler                 542000.00             8
Sabourin, Dany                 512000.00             4
Minard, Chris                  500000.00             0