Aggregates Aggregate

dense_rank()

Arguments & returns

Aggregate

Overload link	Returns
#01	`BIGINT`

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

Haybarn WASM 1.5.5-rc3 · In your browser

Guide example · Run to view results.