/SQL/Create table using the clause with as

Create table using the clause with as

Create table using the clause with as

CREATE TABLE t
AS 
WITH some_data AS ( 
   SELECT 1 as some_value 
   FROM dual

   UNION ALL 

   SELECT 2 
   FROM dual
) 
SELECT * 
FROM some_data

0

Source: stackoverflow.com

Similar codes

3 votes164 views2 answers
Host is not allowed to connect to this mysql server
SQL
15 votes161 views6 answers
Psql
SQL
0 vote175 views1 answer
How to to get time in sql
SQL
0 vote180 views1 answer
Convert sqlalchemy.util._collections to list of string
SQL
3 votes208 views2 answers
Enter mysql command line
SQL
3 votes142 views1 answer
Sql timestamp to date
SQL
1 vote168 views1 answer
How to transfer pandas datafra,e to sqlite
SQL
36 votes156 views6 answers
Delete from where sql
SQL
1 vote162 views1 answer
Display total number of tables in mysql
SQL
0 vote167 views1 answer
How to read the potentail error messages in ssis package
SQL

Share