row_number()

The row number in a window partition

Reference: DuckDB 2.0.0

Arguments & returns

row_number()

window
Overload link Returns
#01 BIGINT
row_number example
SQL
Haybarn WASM 2.0.0-rc12 · In your browser

Engine example with sample data · Run to view results.

More examples

row_number example 2
SQL
Haybarn WASM 2.0.0-rc12 · In your browser

Guide example · Run to view results.

In other engines

Used in larger rewrites 1

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

Snowflakeseq1()

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

SQLGlot example ↗