Sample Header Ad - 728x90

Is there a way to create temporary tables using CTE's and WITH/VALUES in Vertica?

0 votes
0 answers
633 views
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 https://dba.stackexchange.com/questions/86724/how-to-create-a-temporary-table-using-values-in-postgresql
Asked by fcsr (101 rep)
Feb 27, 2020, 07:11 PM