Categories: Window
ROW_NUMBER
Returns the row number for the current row based on the ORDER BY
clause within each partition. Rows containing identical values receive different row numbers.
Syntax
ROW_NUMBER() OVER ( [PARTITION BY partition_expression] [ORDER BY order_expression]) → bigint
- partition_expression: An optional expression that groups rows into partitions.
- order_expression: An optional expression that specifies the order of the rows within each partition.
Examples
SELECT "Category",
"Descript",
"DayOfWeek",
ROW_NUMBER()
OVER (
PARTITION BY "Category"
ORDER BY "DayOfWeek")
FROM Samples."samples.dremio.com"."SF_incidents2016.json"
-- Category, Descript, DayOfWeek, EXPR$3
-- ARSON, ARSON, Friday, 1
-- ARSON, ARSON, Friday, 2
Usage Notes
The example uses Dremio’s Samples Data Lake, which includes sample datasets that you can practice with. You must manually add this data lake. To add in Dremio Cloud, see Add Dremio’s Samples Data Lake to Your Project. Guidance to add in Dremio Software is in development.
Was this page helpful?
Glad to hear it! Thank you for your feedback.
Sorry to hear that. Thank you for your feedback.