Skip to main content
FIRST

Get the first value of a specified field within a range or partition

Updated over 2 months ago

Description

The FIRST() function returns the first value of a specified field within a range or partition. This is useful for identifying the initial entry.

Syntax

FIRST(arg)

Output

Varies based on input field type

Variables

  1. arg: the field from which to fetch the first value.

Example

FIRST(Value) Over (Partition by Group)

ID

Group

Value

FIRST

1

A

10

10

2

A

20

10

3

A

15

10

4

B

30

30

5

B

40

30

Did this answer your question?