clickhouseUsing multiple variables in "WITH" queries
WITH 1 AS a, 100 as b SELECT * FROM tbl WHERE col > a AND col < bctrl + cWITHallows defining user variables | 1 AS afirst variable and value |
100 as bsecond variable and value | col > a AND col < busing both variable in a query |
More of Clickhouse
- How to execute SQL query from a file
- List all tables from all database
- Get total database size
- Convert array to rows
- How to restart Clickhouse server
- Using variables in queries
- Select where date column is between dates
- Show running queries
- Select countIf usage example
- Import CSV data into table from a file
See more codes...