sql横排问题,在线等待

Question

错了，应该是
标志 年月    1号 2号 3号......  28号 29号 30号 31号  次数 
a1   2004-01 0   0   0           1    1    1    0      3
a1   2004-02 1   0   0           0    0    0    0      1
a2   2004-01 0   0   0           0    0    0    1      1
a2   2004-02 2   0   0           0    0    0    0      2

Answer 1

select 标志,to_char(日期,'yyyy-mm'),sum(decode(to_char(日期,'dd'),01,次数,0)),
sum(decode(to_char(日期,'dd'),02,次数,0)),sum(decode(to_char(日期,'dd'),03,次数,0)),...sum(decode(to_char(日期,'dd'),31,次数,0)) from aaa 
group by  标志,to_char(日期,'yyyy-mm')