Set up docs MCPIntroduced in: v24.2.0
Returns an array with the first N items in ascending order.
Syntax
groupArraySorted(N)(column)Arguments
column— Column for which to group into an array.Any
Returned value
Returns an array with the first N items in ascending order. Array
Examples
Getting first 10 numbers
SELECT groupArraySorted(10)(number) FROM numbers(100);┌─groupArraySorted(10)(number)─┐
│ [0,1,2,3,4,5,6,7,8,9] │
└──────────────────────────────┘String sorting example
SELECT groupArraySorted(5)(str) FROM (SELECT toString(number) AS str FROM numbers(5));┌─groupArraySorted(5)(str)─┐
│ ['0','1','2','3','4'] │
└──────────────────────────┘