I'm trying to create a temporary table using CTE's/With.
Is there a Vertica equivalent for this approach?
WITH vals (k,v) AS (VALUES (0,-9999), (1, 100))
SELECT * FROM vals;
I want to be able to use the data without creating a temp table
I'm trying to create a temporary table using CTE's/With.
Is there a Vertica equivalent for this approach?
WITH vals (k,v) AS (VALUES (0,-9999), (1, 100))
SELECT * FROM vals;
I want to be able to use the data without creating a temp table
WITH vals (k, v) AS (SELECT 0, -9999 UNION SELECT 1, 100) SELECT * FROM vals;? See the fiddle here. If this works, I can write it up! p.s. welcome to the forum! – Vérace Feb 27 '20 at 19:45VALUESclause in this context! Ah well, so much for my answer... – Vérace Feb 27 '20 at 20:08SELECT BLAH FROM DUAL UNION....– Vérace Feb 27 '20 at 22:34