/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

2 votes174 views1 answer
Brew start postgres manual
SQL
0 vote137 views0 answer
SQL
0 vote180 views1 answer
Remove transient options sql wordpress
SQL
12 votes176 views4 answers
Mysql version query
SQL
0 vote197 views1 answer
Mysql range of dates overlap
SQL
0 vote172 views1 answer
Sql values not in another table
SQL
2 votes167 views3 answers
Application.properties spring boot mysql
SQL
3 votes173 views1 answer
Sql case update
SQL
0 vote179 views1 answer
Drop column from local database postgres pgadmin
SQL
1 vote198 views1 answer
Mamp mysql path mac
SQL

Share