/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

0 vote313 views1 answer
Mysql uuid
SQL
0 vote316 views1 answer
Create table in dbms cmds
SQL
2 votes321 views1 answer
Mysql create user with remote access
SQL
22 votes309 views4 answers
Mysql date_format
SQL
-1 vote349 views1 answer
Difference berween database and data base management system
SQL
0 vote367 views1 answer
How to use mysql_tzinfo_to_sql on windows
SQL
0 vote288 views1 answer
Update using case in mysql
SQL
-1 vote297 views1 answer
Extract Data from SQL Server into XML Format
SQL
1 vote308 views1 answer
How to show index type in postgresql
SQL
-1 vote297 views1 answer
Get id from just inserted row mysql server python
SQL

Share