Replies: 1 comment
-
How about this? CREATE TABLE TestTable AS
WITH SampleData AS (
SELECT 1 AS Number
)
SELECT * FROM SampleData;
SELECT * FROM TestTable; -- works? |
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
It is not possible to have a
CREATE TABLE
statement after aWITH
statement:The workaround is now:
Beta Was this translation helpful? Give feedback.
All reactions