Replies: 3 comments 1 reply
-
CH does not support you need to use aliases https://fiddle.clickhouse.com/18492150-c1d5-496d-a29e-ec79edb88b54 WITH t AS
(
WITH t AS
(
SELECT number + 5 AS number
FROM numbers(3) AS t
)
SELECT number + 5 AS number
FROM t
)
SELECT *
FROM t
┌─number─┐
│ 10 │
│ 11 │
│ 12 │
└────────┘ |
Beta Was this translation helpful? Give feedback.
0 replies
-
how to write recursive cte? |
Beta Was this translation helpful? Give feedback.
1 reply
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
WITH t(number) AS (
WITH t(number) AS
(
SELECT number + 5 from numbers(3) t
)
SELECT number + 5 from t
)
SELECT * FROM t;
now it reported error
Beta Was this translation helpful? Give feedback.
All reactions