/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

12 votes141 views2 answers
Insert multiple rows from another table sql
SQL
0 vote146 views1 answer
Get server date mysql
SQL
5 votes145 views1 answer
Mysql count lines
SQL
0 vote157 views1 answer
Sql query tags
SQL
0 vote153 views1 answer
Buscar nombre de columna en todas las tablas sql server
SQL
0 vote155 views1 answer
Oracle job schedules
SQL
4 votes151 views2 answers
Postgresql default value
SQL
0 vote138 views1 answer
How to make case insensitive in sql
SQL
0 vote144 views1 answer
Kill a pid redshift
SQL
4 votes167 views3 answers
Mysql get column names from table
SQL

Share