Skip to content

rollup()

Combine multiple MaxNBy aggregates

Since 1.16.0

This aggregate combines the aggregates generated by other max_n_by aggregates and returns the maximum values and associated data found across all the aggregated data.

The syntax is:

rollup(
agg MaxNBy
) MaxNBy
NameTypeDefaultRequiredDescription
aggMaxNBy-The aggregates being combined
ColumnTypeDescription
rollupMaxNByAn aggregate over all of the contributing values.