PARTITION BY ORDER BY with Ranking
PARTITION BY ORDER BY with Window Frames
Using PARTITION BY ORDER BY with Analytical Functions
Instruction
Very well done! Let's do a few more exercises.
Exercise
Let's analyze sales data between August 1 and August 3, 2016. For each row, show the StoreId, Day, Transactions and the ranking of the store (based on the daily number of transactions). The store with the greatest number of transactions should get Rank = 1. Use individual row ranks even when two rows share the same value.
Stuck? Here's a hint!
Use ROW_NUMBER() instead of RANK().
