PostgreSQL Function Reference

DENSE_RANK

Assigns a dense rank to each row within a partition.

PostgreSQL 17.5

DENSE_RANK()

Examples

PostgreSQL 17.5

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