/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 vote127 views1 answer
Full syntax inner join
SQL
0 vote157 views2 answers
How to Alter column in SQL Server - NAYCode.com
SQL
4 votes135 views1 answer
What are the data types in sql
SQL
0 vote150 views1 answer
Reset keys in sql
SQL
5 votes142 views1 answer
Sql check if date is between 2 dates
SQL
0 vote137 views1 answer
Delete double on SQL with multiple primary keys
SQL
0 vote144 views1 answer
Exit psql
SQL
0 vote150 views3 answers
How to assign custom id in mysql
SQL
2 votes163 views1 answer
Revokeprivileges mysql
SQL
0 vote139 views1 answer
Sql create table with references not primary key
SQL

Share