/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 vote284 views1 answer
How to define a non primary composite key in sql
SQL
0 vote271 views1 answer
Convert multiple columns to ROws in sql server
SQL
0 vote274 views1 answer
Sql reverse order of results
SQL
0 vote269 views1 answer
Get number of rows in every table mysql
SQL
0 vote266 views1 answer
Get id if is not equal in certain table
SQL
1 vote289 views3 answers
Sql union
SQL
0 vote266 views1 answer
Check if database exists sql
SQL
0 vote264 views1 answer
Phpmyadmin tabellentyp ändern
SQL
0 vote257 views1 answer
Mysql find missing values
SQL
0 vote245 views1 answer
Get all employees if name ends with in sql
SQL

Share