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
- Select sumIf query example
- Convert array to rows
- Get total database size
- Using variables in queries
- Convert hex to text
- How to execute SQL query from a file
- Select where date column is between dates
- List all tables from all database
- String concat
- How to get current datetime
See more codes...