SQL> select * from tb_11;
GG_NO DD_QTY DD_DATE
------ ------ ----------
A 5 2007/06/05
A 6 2007/06/07
B 8 2007/08/23
B 10 2007/09/20
C 12 2007/09/21
SQL>
SQL> select GG_NO,
2 sum(decode(to_number(substr(DD_DATE, 6, 2)), 6, DD_QTY, null)) "6月份",
3 sum(decode(to_number(substr(DD_DATE, 6, 2)), 7, DD_QTY, null)) "7月份",
4 sum(decode(to_number(substr(DD_DATE, 6, 2)), 8, DD_QTY, null)) "8月份",
5 sum(decode(to_number(substr(DD_DATE, 6, 2)), 9, DD_QTY, null)) "9月份"
6 from tb_11
7 group by GG_NO;
GG_NO 6月份 7月份 8月份 9月份
------ ---------- ---------- ---------- ----------
A 11
B 8 10
C 12
GG_NO DD_QTY DD_DATE
------ ------ ----------
A 5 2007/06/05
A 6 2007/06/07
B 8 2007/08/23
B 10 2007/09/20
C 12 2007/09/21
SQL>
SQL> select GG_NO,
2 sum(decode(to_number(substr(DD_DATE, 6, 2)), 6, DD_QTY, null)) "6月份",
3 sum(decode(to_number(substr(DD_DATE, 6, 2)), 7, DD_QTY, null)) "7月份",
4 sum(decode(to_number(substr(DD_DATE, 6, 2)), 8, DD_QTY, null)) "8月份",
5 sum(decode(to_number(substr(DD_DATE, 6, 2)), 9, DD_QTY, null)) "9月份"
6 from tb_11
7 group by GG_NO;
GG_NO 6月份 7月份 8月份 9月份
------ ---------- ---------- ---------- ----------
A 11
B 8 10
C 12