groupArrayLast

Syntax: groupArrayLast(max_size)(x)

Creates an array of the last argument values. For example, groupArrayLast(1)(x) is equivalent to [anyLast (x)].

In some cases, you can still rely on the order of execution. This applies to cases when SELECT comes from a subquery that uses ORDER BY if the subquery result is small enough.

Example

Query:

SELECT groupArrayLast(2)(number+1) numbers FROM numbers(10)

Result:

┌─numbers─┐
│ [9,10]  │
└─────────┘

In compare to groupArray:

SELECT groupArray(2)(number+1) numbers FROM numbers(10)

┌─numbers─┐
│ [1,2]   │
└─────────┘

groupArrayLast

Introduced in: v23.1

Creates an array of the last argument values. For example, groupArrayLast(1)(x) is equivalent to [anyLast(x)]. In some cases, you can still rely on the order of execution. This applies to cases when SELECT comes from a subquery that uses ORDER BY if the subquery result is small enough.

Syntax

groupArrayLast(max_size)(x)

Parameters

max_size — Maximum size of the resulting array. UInt64

Arguments

max_size — Maximum size of the resulting array. UInt64
x — Argument (column name or expression). Any

Returned value

Returns an array of the last argument values. Array(T)

Examples

Usage example

SELECT groupArrayLast(2)(number+1) numbers FROM numbers(10);

┌─numbers─┐
│ [9,10]  │
└─────────┘

Comparison with groupArray

-- Compare with groupArray (first values)
SELECT groupArray(2)(number+1) numbers FROM numbers(10);

┌─numbers─┐
│ [1,2]   │
└─────────┘

groupArrayLast​

groupArrayLast