关于WITH AS 字句

0
自己想要在WITH AS 下使用一个WITH AS 生成的数据作为一个新表怎么写
已邀请:
0

老头子 - 专注是唯一的捷径 2016-10-21 回答

with a as
(...)
,b as
(select * from a)
1

newlove 2016-10-21 回答

with tableA as
(...)
select * from tableA 
0

GeorgeYao - 路漫漫其修远兮,吾将上下而求索! 2016-10-24 回答

with t1 as(
 select 1 as No ,a as x  from dual
 union all
 select 2 as No ,b as x from dual
 union all 
 select 3 as No ,c as x from dual
 union all 
 select 4 as No ,c as x from dual
)
; t2 as(
 select
 x,
 count(*)
 from t1
 group by x
)
select * from t2
 
 

要回复问题请先登录注册