Skip to main content
Skip to main content

groupArraySorted

Returns an array with the first N items in ascending order.

Arguments

  • N – The number of elements to return.

  • column – The value (Integer, String, Float and other Generic types).

Example

Gets the first 10 numbers:

Gets all the String implementations of all numbers in column:

Try ClickHouse Cloud for FREE

Separation of storage and compute, automatic scaling, built-in SQL console, and lots more. $300 in free credits when signing up.

Try it for Free