SQL · Window functions

nth_value()

The nth value in the window frame.

sqlRunnable example sql course

Syntax

nth_value(column, n) over (…)

Example

Open in the lab

WITH lessons(minutes) AS (VALUES (10), (20), (30))
SELECT minutes, nth_value(minutes, 2) OVER (ORDER BY minutes ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) AS second 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

nth_value()

Example

More in this group

Learn this in the course