LAST(value_exp)

Returns Last Value in the unsorted population of value_exp.

Description

This function returns the nth value of the unsorted population of n elements.

 

Example

V1

V2

V3

V4

V5

V6

5

25

2

25

25

30

 

The above example would return 30, because it is the 6th value in the population.

 

Parameters

value_exp can be an expression of any SQL data type.