Introduction
PARTITION BY
Ranking functions
Window Frames
Analytic Functions
PARTITION BY ORDER BY
Order of Evaluation
Finished!
Instruction
Excellent! This is the next-to-last exercise for ranking functions.
Exercise
Show the first and last name of the customer who bought the second-most-recently-purchased GiftCard. Show the payment date also. Assume that an individual rank is assigned for each gift card purchase.
Stuck? Here's a hint!
Use a CTE:
WITH Ranking AS (...) SELECT ...
And pick the row with Rank = 2.
