group by

最新推荐文章于 2024-02-12 17:17:17 发布

yanglei031

最新推荐文章于 2024-02-12 17:17:17 发布

阅读量636

点赞数 1

分类专栏： oracle 文章标签： group by

本文链接：https://blog.csdn.net/yanglei031/article/details/9879375

版权

oracle 专栏收录该内容

5 篇文章 0 订阅

订阅专栏

select org, leaseform, sum(fesitmatecapital)
from (

select a.fesitmatecapital, b.fname_l2 org, c.fname_l2 leaseform
from t_afl_con_contract a
inner join t_org_baseunit b on a.fbusinessorgid = b.fid
inner join t_afl_bd_leaseform c on a.fleaseformid = c.fid)

group by rollup(org, leaseform)
order by org;
--------------------------------
select org, leaseform, sum(fesitmatecapital)
from (

select a.fesitmatecapital, b.fname_l2 org, c.fname_l2 leaseform
from t_afl_con_contract a
inner join t_org_baseunit b on a.fbusinessorgid = b.fid
inner join t_afl_bd_leaseform c on a.fleaseformid = c.fid)

group by cube(org, leaseform)
order by org;
-------------------

select org, leaseform, sum(fesitmatecapital),grouping(org),grouping(leaseform)
from (

select a.fesitmatecapital, b.fname_l2 org, c.fname_l2 leaseform
from t_afl_con_contract a
inner join t_org_baseunit b on a.fbusinessorgid = b.fid
inner join t_afl_bd_leaseform c on a.fleaseformid = c.fid)

group by cube(org, leaseform)
order by org;

-----------------------------

select org, leaseform, sum(fesitmatecapital)
from (

select a.fesitmatecapital, b.fname_l2 org, c.fname_l2 leaseform
from t_afl_con_contract a
inner join t_org_baseunit b on a.fbusinessorgid = b.fid
inner join t_afl_bd_leaseform c on a.fleaseformid = c.fid)

group by grouping sets(org, leaseform)
order by org;