Skip to content
Advertisement

How to save data after using With Clause?

I want to save the data I have after With Clause. Maybe saving into TEMP table or some other data set.

I want to save RESULTS data into some other table in stand of SELECT them, but the select statement is mandatory after WITH clause.

Advertisement

Answer

CTAS (Create Table As Select) is one option:

User contributions licensed under: CC BY-SA
7 People found this is helpful
Advertisement