/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 vote183 views2 answers
Sql query inner join 3 tables
SQL
3 votes184 views1 answer
Oracle drop user
SQL
0 vote171 views1 answer
Remove default constraint sql server
SQL
0 vote156 views0 answer
SQL
16 votes183 views6 answers
Install sqlite3 python
SQL
0 vote183 views1 answer
Left join vs inner join performance
SQL
0 vote200 views1 answer
Connecting mySQL to STS
SQL
2 votes184 views1 answer
Set username and password for postgresql database
SQL
0 vote196 views1 answer
Python connect to mysql in settings.py
SQL
0 vote173 views1 answer
Order by ip address sql
SQL

Share