Skip to main content
Skip to main content
Edit this page

loop

Syntax

Parameters

  • 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 Value

Infinite loop to return query results.

Examples

Selecting data from ClickHouse:

Or using other table function: