Learn the key elements of ClickHouse SQL syntax.
--
, #!
, or #
and continue to the end of the line./*
and */
, can be multiline.SELECT
, select
, SeLeCt
).^[a-zA-Z_][0-9a-zA-Z_]*$
"id"
, `id`
)1
, 0.1
, 1e100
, 0xc0fe
, 0b1101
)'Hello, world'
)[1, 2, 3]
)(1, 'Hello', 2)
)function_name(arg1, arg2, ...)
expression AS alias_name
Are ClickHouse keywords case-sensitive?
How do I comment my ClickHouse SQL queries?
--
, #!
, or #
) for single-line comments, or C-style comments (/* */
) for multi-line comments.Can I use spaces freely in my ClickHouse queries?
What types of literals does ClickHouse support?