Returns the kth largest non-null or nonmissing value.
| Category: | Descriptive Statistics |
| Returned data type: | DOUBLE |
specifies any valid expression that evaluates to a numeric value that represents the largest value to return. For example, if k is 2, the LARGEST function returns the second largest value from the list of expressions.
| Data type | DOUBLE |
| See | <sql-expression> |
| FedSQL Expressions |
specifies any valid expression that evaluates to a numeric value and that is to be searched.
| Data type | DOUBLE |
| See | <sql-expression> |
| FedSQL Expressions |
|
Statements
|
Results
|
|---|---|
select largest(1, 456, 789, .Q, 123); |
789 |
select largest(2, 456, 789, .Q, 123); |
456 |
select largest(3, 456, 789, .Q, 123); |
123 |
select largest(4, 456, 789, .Q, 123); |
. |