Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

Window Functions

Introduction
Simple OVER()
PARTITION BY
Ranking functions
17. Ranking functions – Exercise 3
Window frame
Analytic functions
ORDER BY PARTITION BY
Order of evaluation
Summary

Instruction

Fine! The last but one exercise from ranking functions.

Exercise

Show the first and last name of the customer who bought the second most recent giftcard along with the date when the payment took place. Assume that an individual rank is assigned for each giftcard purchase.

Stuck? Here's a hint!

Use a CTE: WITH ranking AS (...) SELECT ... And pick the row with rank = 2;