> ## Documentation Index
> Fetch the complete documentation index at: https://private-7c7dfe99-mintlify-8a08bda2.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

> Creates an array of the last argument values.

# groupArrayLast

<h2 id="groupArrayLast">
  groupArrayLast
</h2>

Introduced in: v23.1.0

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 theme={null}
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 theme={null}
SELECT groupArrayLast(2)(number+1) numbers FROM numbers(10);
```

```response title=Response theme={null}
┌─numbers─┐
│ [9,10]  │
└─────────┘
```

**Comparison with groupArray**

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

```response title=Response theme={null}
┌─numbers─┐
│ [1,2]   │
└─────────┘
```