3,491
社区成员
发帖
与我相关
我的任务
分享
select b.price * (select power(10, sum(log(10, a.factor)))
from a
where a.a_date > b.b_date)
from b
create table a (
seccode number(12),
a_date date,
factor number(6,4)
);
create table b (
seccode number(12),
b_date date,
price number(12)
);
insert into a values(6000,to_date('2007-07-18','yyyy-mm-dd'),0.9958);
insert into a values(6000,to_date('2008-04-24','yyyy-mm-dd'),0.7656);
insert into a values(6000,to_date('2009-06-09','yyyy-mm-dd'),0.7090);
insert into a values(6000,to_date('2010-06-10','yyyy-mm-dd'),0.7632);
insert into a values(6000,to_date('2011-06-03','yyyy-mm-dd'),0.7600);
insert into a values(6000,to_date('2012-06-26','yyyy-mm-dd'),0.9640);
insert into b values(6000,to_date('2008-04-01','yyyy-mm-dd'),15);
insert into b values(6000,to_date('2008-04-12','yyyy-mm-dd'),16);
insert into b values(6000,to_date('2009-04-12','yyyy-mm-dd'),17);
insert into b values(6000,to_date('2011-04-12','yyyy-mm-dd'),13);
insert into b values(6000,to_date('2012-04-12','yyyy-mm-dd'),16);