PostgreSQL Function Reference

RANK

Assigns a rank to each row within a partition.

PostgreSQL 17.5

RANK()

Examples

PostgreSQL 17.5

SELECT RANK() OVER(
		ORDER BY unit_price DESC
	)
FROM Payments;