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:
