Dremio Cloud
Dremio Software
 
On this page

    Categories: Window

    RANK

    Returns the rank of the current row within its partition and placement order. Rows that are equal have the same rank. However, the count of tied rows is added to the next rank, instead of being incremented by one. The rank value starts at 1 and increases sequentially.

    Syntax

    RANK() 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

    RANK example 
    SELECT "Category", 
  "Descript", 
  "DayOfWeek",
  RANK() 
    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, Monday, 40