I am trying to create a table for the results of my select query as I need to run some analysis on them.
The select ran and I have around 60k rows in the result. When I try to create a table, it provides me with error 3706.
Can you please help?
DieterCREATE TABLE user_work.GHH_UK_RET
Pls add " WITH DATA " in the end and run the code.
Below is the syntax
Creat Table <db_name>.<table_name>
WITH DATA ;
u need to give WITH DATA in the end after your select clause ends..
CREATE TABLE A AS(SEL * FROM B)WITH DATA