5,889
社区成员
发帖
与我相关
我的任务
分享
create table test
(
date varchar(10),
data numeric(10,2)
);
insert into test values('20101001',1.00);
insert into test values('20101001',53.2);
insert into test values('20101001',871.20);
insert into test values('20101002',81.90);
insert into test values('20101002',39.2);
insert into test values('20101002',51.9);
select sum(a.data-b.data),sum(b.data),sum(a.data-b.data)/sum(b.data) from test a left join test b on date(substr(a.date,1,4) || '-' || substr(a.date,5,2) || '-' || substr(a.date,7,2)) = date(substr(b.date,1,4) || '-' || substr(b.date,5,2) || '-' || substr(b.date,7,2)) + 1 day where a.date = '20101002';