loop Table Function
Syntax
Arguments
Argument | Description |
---|---|
database | database name. |
table | table name. |
other_table_function(...) | other table function. Example: SELECT * FROM loop(numbers(10)); other_table_function(...) here is numbers(10) . |
Returned values
Infinite loop to return query results.
Examples
Selecting data from ClickHouse:
Or using other table functions: