Database & utility
window
row_number()
The row number in a window partition
Reference: DuckDB 2.0.0
Arguments & returns
row_number()
window
| Overload link | Returns |
|---|---|
| #01 | BIGINT |
Example
1 more ↓Haybarn WASM 2.0.0-rc12 · In your browser
Engine example with sample data · Run to view results.
More examples
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
SELECT (ROW_NUMBER() OVER (ORDER BY 1 NULLS FIRST) - 1) % 256 FROM test