Aggregates Aggregate

row_number()

Arguments & returns

Aggregate

Overload link	Returns
#01	`BIGINT`

SELECT fruit, row_number() OVER (ORDER BY quantity DESC) AS position
FROM (VALUES ('apples', 12), ('pears', 8)) AS data(fruit, quantity);

Haybarn WASM 1.5.5-rc3 · In your browser

Guide example · Run to view results.

Used in larger rewrites 1

These examples use row_number as one part of a larger SQL translation.

SELECT SEQ1() FROM test

In DuckDB

SELECT (ROW_NUMBER() OVER (ORDER BY 1 NULLS FIRST) - 1) % 256 FROM test