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 in MS SQL Server

Introduction
ROWS
12. Abbreviations – exercise
RANGE
Default window frame
Summary

Instruction

Great! Let's do a practice exercise.

Exercise

For each SingleOrder, show its PlacedDate, TotalPrice and the average price (calculated from the current SingleOrder and the three previous orders in terms of the PlacedDate). Name the column AvgTotalPrice.

Stuck? Here's a hint!

Use ROWS 3 PRECEDING.