Skip to main content

RANGE

Returns an array collected by [start, end).

Syntax

RANGE( <start>, <end> )

Examples

SELECT RANGE(1, 5);

┌───────────────┐
│ range(1, 5)
├───────────────┤
[1,2,3,4]
└───────────────┘
Try Databend Cloud for FREE

Multimodal, object-storage-native warehouse for BI, vectors, search, and geo.

Snowflake-compatible SQL with automatic scaling.

Sign up and get $200 in credits.

Try it today