Introduction
Ranking functions
Instruction
Very good! You may wonder if you can use regular ORDER BY with the ranking functions. You can: the ranking function and the external ORDER BY are independent. The ranking function returns the rank with respect to the order provided within OVER.
Let's look at an example:
SELECT Name, RANK() OVER (ORDER BY EditorRating ASC) AS Ranking FROM Game ORDER BY Size DESC;
This query returns each game's name and rank (based on its editor ranting). The returned rows are in descending order based on the size of the game.
Exercise
Find each game's name, genre, and its rank by size. Name the column Ranking. Then order the games by release date with the newest games coming first.
