SQL Notebook (logo)

RANGE Function

Returns a table containing a list of count integers. The first number is start, and the following numbers are produced by successively incrementing by step (1 by default). This function is used in the FROM clause of a SELECT statement and can participate in JOINs as if it were a table.

Syntax

RANGE(start, count, [step])

Arguments

Return Value

A table with a single column named number.

Examples