SELECT * FROM ( (SELECT SUM(A) SUM_A FROM SSIC) A , (SELECT B , C FROM SSIC) )这样应该可以,利用笛卡尔乘积
select m.*,n.* from (select b,c from ssic group by b,c) m,(select sum(a) a from ssic ) n--example: SQL> SELECT * FROM BAO_TEMP 2 / ID NAME RIGHT ---------- ---------- ---------- 1 A R 2 A W 3 B R 4 B W ---------------------------------------- SQL> select n.*,m.* 2 from (select name,right from bao_temp group by name,right) m, 3 (select sum(id) id from bao_temp) n 4 / ID NAME RIGHT ---------- ---------- ---------- 10 A R 10 A W 10 B R 10 B W
(SELECT SUM(A) SUM_A FROM SSIC) A , (SELECT B , C FROM SSIC)
)这样应该可以,利用笛卡尔乘积
group by b,c) m,(select sum(a) a from ssic ) n--example:
SQL> SELECT * FROM BAO_TEMP
2 / ID NAME RIGHT
---------- ---------- ----------
1 A R
2 A W
3 B R
4 B W
----------------------------------------
SQL> select n.*,m.*
2 from (select name,right from bao_temp group by name,right) m,
3 (select sum(id) id from bao_temp) n
4 / ID NAME RIGHT
---------- ---------- ----------
10 A R
10 A W
10 B R
10 B W