【SQL练习】要求编写SQL语句查询2006年8月1日～31日每一天的当月累计销售金额。

create table tab3(
     company varchar2(20),
     agencyid varchar2(10),
     productid varchar2(3),
     wrcvdate number,
     amt number(17, 6)
)
insert into tab3 (company, agencyid, productid, wrcvdate, amt) 
values ('平安', '001', '100', 20060701, 10.21);
insert into tab3 (company, agencyid, productid, wrcvdate, amt) 
values ('平安', '001', '100', 20060801, 10.21);
insert into tab3 (company, agencyid, productid, wrcvdate, amt) 
values ('平安', '002', '100', 20060802, 10.00);
insert into tab3 (company, agencyid, productid, wrcvdate, amt) 
values ('平安', '003', '100', 20060803, 10.21);
insert into tab3 (company, agencyid, productid, wrcvdate, amt) 
values ('平安', '004', '100', 20060804, 10.21);
insert into tab3 (company, agencyid, productid, wrcvdate, amt) 
values ('平安', '005', '100', 20060820, 10.21);
insert into tab3 (company, agencyid, productid, wrcvdate, amt) 
values ('平安', '006', '100', 20060827, 10.21);
insert into tab3 (company, agencyid, productid, wrcvdate, amt) 
values ('平安', '007', '100', 20060831, 10.21);
commit;

select t.*,
       sum(t.amt) over(order by t.amt rows between unbounded preceding and current row) 每一天的累计销售金额
  from tab3 t
 where t.wrcvdate >= 20060801
   and t.wrcvdate <= 20060831;