# groupArrayLast (/docs/reference/sql/aggregate-functions/grouparraylast)



This page describes the RawTree engine binary used to generate this reference. It does not define Query API support. Descriptions retain upstream ClickHouse terminology. See [SQL interface scope](/docs/reference/clickhouse-compatibility#service-interfaces).

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**

```sql
groupArrayLast(max_size)(x)
```

**Parameters**

* `max_size` — Maximum size of the resulting array. [`UInt64`](/reference/data-types/int-uint)

**Arguments**

* `max_size` — Maximum size of the resulting array. [`UInt64`](/reference/data-types/int-uint)
* `x` — Argument (column name or expression). [`Any`](/reference/data-types)

**Returned value**

Returns an array of the last argument values. [`Array(T)`](/reference/data-types/array)

**Examples**

**Usage example**

```sql title=Query
SELECT groupArrayLast(2)(number+1) numbers FROM numbers(10);
```

```text title=Response
┌─numbers─┐
│ [9,10]  │
└─────────┘
```

**Comparison with groupArray**

```sql title=Query
-- Compare with groupArray (first values)
SELECT groupArray(2)(number+1) numbers FROM numbers(10);
```

```text title=Response
┌─numbers─┐
│ [1,2]   │
└─────────┘
```

*Introduced in version 23.1.0.*
