SQL · Window functions

last_value()

The last value in the current window frame. Widen the frame to see the group’s last row.

sqlRunnable example sql course

Syntax

last_value(column) over (…)

Example

Open in the lab

WITH lessons(minutes) AS (VALUES (10), (20))
SELECT minutes, last_value(minutes) OVER (ORDER BY minutes ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) AS last FROM lessons;

Learn this in the course

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

Open the course

last_value()

Example

More in this group

Learn this in the course