oracle旬统计,求汇总旬度数据的SQL语句

[php]

SQL>Create table test_rq as select sysdate+rownum as rq,rownum as d from all_objects where rownum < 500 ;

Table created.

SQL>select sum(d),to_char(rq,'YYYY-MM-')||

(case when to_char(rq,'dd') <='10' then 'A'

when to_char(rq,'dd') <='20' then 'B'

else 'C' END)

from test_rq

group by to_char(rq,'YYYY-MM-')||

(case when to_char(rq,'dd') <='10' then 'A'

when to_char(rq,'dd') <='20' then 'B'

else 'C' END)

SUM(NUM) TO_CHAR(R

---------- ---------

21 2005-06-B

115 2005-06-C

215 2005-07-A

315 2005-07-B

462 2005-07-C

525 2005-08-A

625 2005-08-B

803 2005-08-C

835 2005-09-A

935 2005-09-B

1035 2005-09-C

SUM(NUM) TO_CHAR(R

---------- ---------

1135 2005-10-A

1235 2005-10-B

1474 2005-10-C

1445 2005-11-A

1545 2005-11-B

1645 2005-11-C

1745 2005-12-A

1845 2005-12-B

2145 2005-12-C

2055 2006-01-A

2155 2006-01-B

SUM(NUM) TO_CHAR(R

---------- ---------

2486 2006-01-C

2365 2006-02-A

2465 2006-02-B

2044 2006-02-C

2645 2006-03-A

2745 2006-03-B

3135 2006-03-C

2955 2006-04-A

3055 2006-04-B

3155 2006-04-C

3255 2006-05-A

SUM(NUM) TO_CHAR(R

---------- ---------

3355 2006-05-B

3806 2006-05-C

3565 2006-06-A

3665 2006-06-B

3765 2006-06-C

3865 2006-07-A

3965 2006-07-B

4477 2006-07-C

4175 2006-08-A

4275 2006-08-B

4818 2006-08-C

SUM(NUM) TO_CHAR(R

---------- ---------

4485 2006-09-A

4585 2006-09-B

4685 2006-09-C

4785 2006-10-A

4885 2006-10-B

2979 2006-10-C

[/php]