/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

9 votes330 views4 answers
How to remove duplicate in sql
SQL
0 vote338 views1 answer
Aktor yang pernah terlibat lebih dari 3 film di sql
SQL
1 vote336 views2 answers
Replace text in sql
SQL
0 vote352 views1 answer
Setting default value for Boolean data type in SQL
SQL
3 votes361 views1 answer
Postgres add not null to existing column
SQL
0 vote392 views2 answers
How to truncate all table in mysql workbench
SQL
2 votes317 views1 answer
Mysql auto increment jumping
SQL
2 votes364 views3 answers
Sql truncate table
SQL
0 vote443 views1 answer
InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
SQL
0 vote366 views1 answer
Sql last 3 rows
SQL

Share