/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 votes191 views1 answer
Q operator in sql
SQL
0 vote192 views1 answer
Oracle list proxy users
SQL
9 votes204 views4 answers
SQL Date Format
SQL
7 votes199 views6 answers
Nth highest salary in sql
SQL
3 votes181 views1 answer
What is having clause
SQL
3 votes214 views6 answers
Jwt laravel
SQL
0 vote223 views1 answer
How do I insert a blob in SQL?
SQL
0 vote211 views1 answer
Create boolean column in MySQL with false as default value?
SQL
0 vote202 views1 answer
Xamarin sql lite create table if not exist
SQL
0 vote216 views1 answer
Mssql unique key accept nulls
SQL

Share