SORTFIRST(value_exp)

Returns the First Item in a Sorted Population of value_exp.

Description

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

 

Example:

V1

V2

V3

V4

V5

V6

5

25

2

25

25

30

The above example would return 2, because it is the 1st value of the sorted population.

 

Parameters

value_exp can be an expression of any SQL data type.