是这样么? select Time,createTime,changeTime,sum(1) from TableName group by Time,createTime,changeTime 把你的意思可以再说清楚点。
select a.Time,a.createsum,b.changesum from (select time ,sum(createTime) createsum from table_name group by time) a, (select time ,sum(changeTime) changesum from table_name group by time) b where a.time=b.time order by a.time;
select a.a 日期,a.b 创建,b.b 修改 from (select trunc(create)a,sum(money)b from tt group by trunc(create))a, (select trunc(changetime)a,sum(money)b from tt group by trunc(changetime))b where a.a=b.a
select case when a.a is null then b.a else a.a end 日期, a.b 创建,b.b 修改 from (select trunc(create)a,sum(money)b from tt group by trunc(create))a full join (select trunc(changetime)a,sum(money)b from tt group by trunc(changetime))b on a.a=b.a 这样比较好
select Time,createTime,changeTime,sum(1)
from TableName
group by Time,createTime,changeTime
把你的意思可以再说清楚点。
from (select time ,sum(createTime) createsum from table_name group by time) a,
(select time ,sum(changeTime) changesum from table_name group by time) b
where a.time=b.time
order by a.time;
我想汇总第一列时时间,比如:20090901,20090902
第二列是9月1日创建的订单的价格的总和,
第三列是9月1日修改订单的价格的总和.
我想汇总第一列时时间,比如:20090901,20090902
第二列是9月1日创建的订单的价格的总和,
第三列是9月1日修改订单的价格的总和.
(select trunc(create)a,sum(money)b
from tt group by trunc(create))a,
(select trunc(changetime)a,sum(money)b
from tt group by trunc(changetime))b
where a.a=b.a
a.b 创建,b.b 修改 from
(select trunc(create)a,sum(money)b
from tt group by trunc(create))a
full join
(select trunc(changetime)a,sum(money)b
from tt group by trunc(changetime))b
on a.a=b.a
这样比较好