17,377
社区成员
发帖
与我相关
我的任务
分享
create table test01
(
c1 date,
c2 number
)
insert into test01 values(to_date('2005-01-01','yyyy-mm-dd'),1);
insert into test01 values(to_date('2005-01-01','yyyy-mm-dd'),3);
insert into test01 values(to_date('2005-01-02','yyyy-mm-dd'),5);
select * from test01;
select c1,sum(c2) from test01 group by rollup(c1)
select nvl(to_char(c1,'yyyy-mm-dd'),'合计'),sum(c2) from test01 group by rollup(c1)
select (case grouping(c1) when 1 then '合计' else c1 end) as riqi,sum(c2) from test01 group by rollup(c1)
select decode(grouping(c1),1,'合计',to_char(c1,'yyyy-mm-dd')),sum(c2) from test01 group by rollup(c1)