nth_value()

Returns value evaluated at the row that is the n'th row of the window frame (counting from 1); returns NULL if there is no such row.

Signature

nth_value ( value anyelement, n integer ) → anyelement

Examples

SELECT product, nth_value(product, 2) OVER (ORDER BY id) FROM orders;

 product  | nth_value 
----------+-----------
 keyboard | NULL
 monitor  | monitor
 keyboard | monitor
 mouse    | monitor
 monitor  | monitor
 cable    | monitor
(6 rows)

Run against PostgreSQL 18.6 on 2026-09-13. This is the output we got, not the documentation’s.

Want to run this against your own PostgreSQL server from an iPhone, iPad or Mac? These are ours — every connection goes straight from the device to your database, with no account and no server of ours in between.

Postgres & FriendsPostgreSQL and the open-source engines around it

Signature and description adapted from the PostgreSQL manual, used under the PostgreSQL License. PostgreSQL is a registered trademark of the PostgreSQL Community Association of Canada. This page is not affiliated with the PostgreSQL Global Development Group.