PostgreSQL Function Reference

ROW_NUMBER

Assigns a unique number to each row within a partition.

PostgreSQL 17.5

ROW_NUMBER()

Examples

PostgreSQL 17.5

SELECT ROW_NUMBER() OVER(
		ORDER BY birthday
	)
FROM FamilyMembers;