SQL · Window functions

first_value()

The first value in the window frame.

sqlRunnable example sql course

Syntax

first_value(column) over (…)

Example

Open in the lab

WITH lessons(minutes) AS (VALUES (10), (20))
SELECT minutes, first_value(minutes) OVER (ORDER BY minutes) AS first FROM lessons;

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