SQL · Window functions

named window

Names a window definition and reuses it across several columns.

sqlRunnable example sql course

Syntax

window w as (order by …)

Example

Open in the lab

WITH lessons(minutes) AS (VALUES (10), (20))
SELECT minutes, row_number() OVER w AS position FROM lessons WINDOW w AS (ORDER BY minutes);

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.