PostgreSQL Function Reference

LAST_VALUE

Returns the last value in an ordered set of values.

PostgreSQL 17.5

LAST_VALUE(column)

column

The column

Examples

PostgreSQL 17.5

SELECT LAST_VALUE(member_name) OVER(
		PARTITION BY STATUS
		ORDER BY birthday ROWS BETWEEN CURRENT ROW
			AND UNBOUNDED FOLLOWING
	)
FROM FamilyMembers;