FIRST(value_exp)

Returns the first value in the unsorted population of value_exp.

Description

This function returns the 1st value of the unsorted population.

 

Example

V1

V2

V3

V4

V5

V6

5

25

2

25

25

30

 

The above example would return 5, because it is the 1st value in the population.

 

Parameters

value_exp can be an expression of any SQL data type.