/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 votes100 views1 answer
Latest record in sql
SQL
0 vote137 views1 answer
Postgresql not in alternative
SQL
3 votes136 views2 answers
Sql random integer
SQL
0 vote136 views1 answer
Closure in sql
SQL
0 vote163 views1 answer
Linux upload database to mysql
SQL
-2 votes140 views1 answer
No module named '_sqlite3
SQL
10 votes140 views3 answers
How to fetch first 5 characters in sql
SQL
0 vote154 views1 answer
Postgres clear table
SQL
0 vote148 views1 answer
Sql select sum group by id laravel join
SQL
0 vote143 views1 answer
Alter table change default
SQL

Share