iT邦幫忙

0

幫忙把MSSQL CTE 改寫成 ORACLE CTE

MSSQL如下,感謝!!

;with
cte1 (別名)
as (select ...)
,
cte2 (別名)
as (select ...)
,
cte3 (別名)
as (select ...)

select * from cte1,cte2,cte3 
;with
cte1 (別名)
as (select ...)
,
cte2 (別名)
as (select ...)
,
cte3 (別名)
as (select ...)

select * from cte1,cte2,cte3

就這樣吧。
不是找到問題了,oracle 的with不用加分號 ;

尚未有邦友回答

立即登入回答