Skip to content

Latest commit

 

History

History
34 lines (27 loc) · 1.05 KB

ntile.md

File metadata and controls

34 lines (27 loc) · 1.05 KB
description
Equally splits the rows in each partition into ranked parts specified by the integer value and starting from 1. This function requires the ORDER BY clause.

NTILE

Syntax

NTILE(buckets) OVER (PARTITION BY partition_expression ORDER BY order_expression) → int

  • buckets: A positive integer literal.
  • partition_expression: An expression that groups rows into partitions.
  • order_expression: An expression that specifies the order of the rows within each partition.

Examples

{% code title="NTILE example" %}

SELECT "Category", 
  "Descript", 
  "DayOfWeek",
  NTILE(1) 
    OVER (
      PARTITION BY "Category" 
      ORDER BY "DayOfWeek")
FROM eth.recent_blocks 

-- Category, Descript, DayOfWeek, EXPR$3
-- ARSON, ARSON, Friday, 1 
-- EMBEZZLEMENT, EMBEZZLED VEHICLE, Friday, 1

{% endcode %}