PostgreSQL Function Reference

LEAD

Provides access to a row at a specified offset after the current row.

PostgreSQL 17.5

LEAD(column [, offset ] [, default])

column

The column

offset

The offset

default

Default value

Examples

PostgreSQL 17.5

SELECT LEAD(member_name) OVER(
		ORDER BY birthday
	)
FROM FamilyMembers;