双重统计

[winner381]

红色字是一模一样的，感觉很不苗条
select
(select sum(f_qcysje) from (select * from t_kh order by s_sfxtnz desc,I_szsj,i_px)
start with s_khID=t.s_khid connect by prior s_khID=S_FJID) 期初应收金额,
(select sum(f_qcyfje) from (select * from t_kh order by s_sfxtnz desc,I_szsj,i_px)
start with s_khID=t.s_khid connect by prior s_khID=S_FJID) 期初应付金额
from t_kh t where t.s_fjid='KH_000'
union all
select sum(期初应收金额),sum(期初应付金额)
from
(select
(select sum(f_qcysje) from (select * from t_kh order by s_sfxtnz desc,I_szsj,i_px)
start with s_khID=t.s_khid connect by prior s_khID=S_FJID) 期初应收金额,
(select sum(f_qcyfje) from (select * from t_kh order by s_sfxtnz desc,I_szsj,i_px)
start with s_khID=t.s_khid connect by prior s_khID=S_FJID) 期初应付金额
from t_kh t where t.s_fjid='KH_000')

[crazylaa]

rollup?

[iqlife]

with total_sum as
(红色部分)
select *　from total_sum
union all
select sum(期初应收金额),sum(期初应付金额)
from total_sum
苗条点了

[tangren]

with 就是Sql减肥茶！！

[crazylaa]

[Quote=引用 2 楼 java3344520 的回复:]

with total_sum as
(红色部分)
select *　from total_sum
union all
select sum(期初应收金额),sum(期初应付金额)
from total_sum
苗条点了
[/Quote]

学习减肥。