Skip to content

Latest commit

 

History

History
29 lines (22 loc) · 1.28 KB

first_value.md

File metadata and controls

29 lines (22 loc) · 1.28 KB
description
Returns the first value within an ordered group of a result set.

FIRST_VALUE

Syntax

FIRST_VALUE(expression) OVER ( [PARTITION BY partition_expression] [ORDER BY order_expression] [ (ASC | DESC) ] ) → same as input type

  • expression: The expression that determines the return value.
  • partition_expression: An optional expression that groups rows into partitions. You can specify a single expression or a comma-separated list of expressions. For example, PARTITION BY column1, column3, …
  • order_expression: An expression that specifies the order of the rows within each partition. You can specify a single expression or a comma-separated list of expressions. For example, PARTITION BY column1, column3, …

Examples

{% code title="FIRST_VALUE example" %}

SELECT city, state, pop, 
FIRST_VALUE(pop) OVER (PARTITION BY state ORDER BY city)
FROM  eth.recent_blocks 

-- city, state, pop, EXPR$3
-- 98791, AK, 5345, 5345
-- AKHIOK, AK, 13309, 5345
-- AKIACHAK, AK, 481, 5345
-- ... 

{% endcode %}