ReferenceSQL ReferenceAggregate Functions

nothingUInt64

Internal aggregate function that accepts any arguments and returns a UInt64; a variant of the nothing aggregate function used where a default numeric value is required.

Internal aggregate function that accepts any arguments and returns a UInt64; a variant of the nothing aggregate function used where a default numeric value is required.

nothingNull

Internal aggregate function that accepts any arguments and returns a value of type Nullable(Nothing); the nullable variant of the nothing aggregate function.

nth_value

Returns the first non-NULL value evaluated against the nth row (offset) in its ordered frame.