oracleÈÕÆÚ·Ö¶Î

ÓÐÒ»±í´æ´¢ÄÚÈÝΪ£º
t_date          t_bl
2007-02-18      1.5%
2007-03-05      1.8%
2007-03-22      2.0%
2007-04-15      3.0%
2007-05-20      2.0%
2007-06-07      1.7%


ÏÖÔÚÎÒÒª°´ÔÂÈ¡³ö2007Äê3ÔÂ1ÈÕµ½2007Äê3ÔÂ31ÈÕ×ܹ²·ÖÁ˼¸¶Î£¬Ã¿¶ÎÓм¸Ì죿½á¹ûÈçÏ£º

ÈÕÆÚ        ÌìÊý
2007-03-05  5
2007-03-22  17
2007-03-31  9

ÈçºÎдSQL!!!

---

SQL code:

SQL>
SQL> with tab as
2 (
3 select to_date('2007-02-18','yyyy-MM-dd') t_date,'1.5%' t_bl from dual
4 union all
5 select to_date('2007-03-05','yyyy-MM-dd') t_date, '1.8%' t_bl from dual
6 union all
7 select to_date('2007-03-22','yyyy-MM-dd') t_date,'2.0%' t_bl from dual
8 union all
9 select to_date('2007-04-15','yyyy-MM-dd') t_date,'3.0%' t_bl from dual
10 union all
11 select to_date('2007-05-20','yyyy-MM-dd') t_date,'2.0%' t_bl from dual
12 union all
13 select to_date('2007-06-07','yyyy-MM-dd') t_date,'1.7%' t_bl from dual
14 )
15 select t_date, t_date - p_date+1 intv
16 from (select t_date,
17 lag(t_date, 1, trunc(t_date, 'mm')) over(partition by trunc(t_date, 'mm')