Window Frames
Learn how to calculate aggregate expression over a sliding window.
We'll cover the following
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.