Oracle 统计一周内，每天的数值总额

select * from (
select nvl(sum(dnet),0) "COUNT",max(d.dt) date2 from syssale001 right join 
(select to_char(TRUNC(sysdate)-interval '7' day  + LEVEL,'yyyy-MM-dd')  AS dt from dual  CONNECT BY LEVEL <= 7) d 
on d.dt=to_char(saletime,'yyyy-mm-dd') group by d.dt order by d.dt desc)

dnet：数值字段（数量）

syssale001：所在表（订单主表）