Aggregates Aggregate

rank()

Arguments & returns

Aggregate

Overload link	Returns
#01	`BIGINT`

SELECT quantity, rank() OVER (ORDER BY quantity DESC) AS position
FROM (VALUES (12), (12), (8)) AS data(quantity);

Haybarn WASM 1.5.6-rc6 · In your browser

Guide example · Run to view results.