- Overview
- Data types
- Commands
- Functions
- Overview
- Aggregate
- Conditional expression
- Conversion
- Date and time
- Numeric
- String
- Semi-structured data
- Window
- System
On this page
row_number
Returns the zero-based row number within the current window.
Syntax
row_number()
Returns
Returns int.
Examples
VALUES ('a'), ('b'), ('c')
WINDOW row_number();