兩個無關聯(lián)條件的結果進行拼接
2 回答
湖上湖
TA貢獻2003條經(jīng)驗 獲得超2個贊
如果數(shù)據(jù)類型相似,可以使用as配合union來結合,例如
select c1 as a,c2 as b,null as c from t1 union
select cc1 as a,cc2 as b,cc3 as c from t2;
其中,使用null來確保連個select有相同的列數(shù).
前提是兩個select選擇的同一列的數(shù)據(jù)類型相似.
PIPIONE
TA貢獻1829條經(jīng)驗 獲得超9個贊
with t1 as (select 1 from dual),
t2 as (select 2 from dual)
select * from t1, t2
- 2 回答
- 0 關注
- 1381 瀏覽
添加回答
舉報
0/150
提交
取消