PostgreSQL Function Reference

FIRST_VALUE

Returns the first value in an ordered set of values.

PostgreSQL 17.5

FIRST_VALUE(column)

column

The column

Examples

PostgreSQL 17.5

SELECT FIRST_VALUE(member_name) OVER(
		PARTITION BY STATUS
		ORDER BY birthday
	)
FROM FamilyMembers;