Window Frames

Learn how to calculate aggregate expression over a sliding window.

Overview

The PARTITION clause in an aggregate expression can calculate the difference between the temperature on each day and the hottest day ever in the same city:

Get hands-on with 1200+ tech skills courses.