/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

1 vote193 views2 answers
Mysql order by date asc null last
SQL
0 vote232 views1 answer
TSQL function split string
SQL
0 vote203 views1 answer
How to Group by and concatenate arrays with all columns in PostgreSQL
SQL
0 vote200 views1 answer
Check psql validity function
SQL
16 votes209 views1 answer
Mysql mediumint max value
SQL
0 vote234 views1 answer
Postgres list users and roles
SQL
0 vote261 views1 answer
Sql ssrs
SQL
2 votes193 views3 answers
Postgres remove foreign key constraint
SQL
0 vote219 views2 answers
Dbms transaction tutorialspoint
SQL
0 vote203 views1 answer
Asp.net core sql server stored procedure
SQL

Share