max_n()
Find the largest values in a set of data
Since 1.16.0
Construct an aggregate which will keep track of the largest values passed through it.
Arguments
Section titled “Arguments”The syntax is:
max_n( value BIGINT | DOUBLE PRECISION | TIMESTAMPTZ, capacity BIGINT) MaxN| Name | Type | Default | Required | Description |
|---|---|---|---|---|
value | BIGINT | DOUBLE PRECISION | TIMESTAMPTZ | - | ✔ | The values passed into the aggregate |
capacity | BIGINT | - | ✔ | The number of values to retain. |
Returns
Section titled “Returns”| Column | Type | Description |
|---|---|---|
| max_n | MaxN | The compiled aggregate. Note that the exact type will be MaxInts, MaxFloats, or MaxTimes depending on the input type |