�ｿｽ�ｿｽ�ｿｽﾊ費ｿｽ�ｿｽ�ｿｽ繧ｰ�ｿｽ�ｿｽ�ｿｽl�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽﾊに集�ｿｽv�ｿｽ�ｿｽ�ｿｽ�ｿｽﾖ撰ｿｽ�ｿｽ�ｿｽ�ｿｽU�ｿｽFSQL�ｿｽN�ｿｽ�ｿｽ�ｿｽj�ｿｽb�ｿｽN�ｿｽi5�ｿｽj�ｿｽi1/3 �ｿｽy�ｿｽ[�ｿｽW�ｿｽj

�ｿｽ{�ｿｽA�ｿｽﾚゑｿｽSQL�ｿｽﾌ会ｿｽ�ｿｽp�ｿｽﾍゑｿｽg�ｿｽﾉ付�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽG�ｿｽ�ｿｽ�ｿｽW�ｿｽj�ｿｽA�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽﾉ、�ｿｽ�ｿｽ�ｿｽﾜゑｿｽ�ｿｽﾜなテ�ｿｽN�ｿｽj�ｿｽb�ｿｽN�ｿｽ�ｿｽ�ｿｽﾐ介す�ｿｽ�ｿｽBSQL�ｿｽﾌ奇ｿｽ{�ｿｽ\�ｿｽ�ｿｽ�ｿｽﾍ包ｿｽ�ｿｽﾕなゑｿｽ�ｿｽﾌゑｿｽ�ｿｽ�ｿｽ�ｿｽA�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽﾅ奇ｿｽ�ｿｽp�ｿｽ�ｿｽ�ｿｽ�ｿｽﾉは具ｿｽ�ｿｽﾈ擾ｿｽ�ｿｽI�ｿｽﾈ記�ｿｽq�ｿｽ�理会ｿｽ�ｿｽ�ｿｽ�ｿｽ驍ｾ�ｿｽ�ｿｽ�ｿｽﾅは不�ｿｽ\�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽB�ｿｽ{�ｿｽA�ｿｽﾚは、�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽﾈ��ｿｽ�ｿｽ[�ｿｽ�ｿｽ�ｿｽ}�ｿｽK�ｿｽW�ｿｽ�ｿｽ�ｿｽu�ｿｽ�ｿｽ�ｿｽ�ｿｽI�ｿｽI�ｿｽ�ｿｽ�ｿｽI Oracle - �ｿｽﾇゑｿｽ�ｿｽﾕり検�ｿｽﾘ撰ｿｽ�ｿｽ�ｿｽ�ｿｽv�ｿｽ�発行�ｿｽ�ｿｽ�ｿｽ�ｿｽC�ｿｽ�ｿｽ�ｿｽT�ｿｽC�ｿｽg�ｿｽe�ｿｽN�ｿｽm�ｿｽ�ｿｽ�ｿｽW�ｿｽ[�ｿｽﾌコ�ｿｽ�ｿｽ�ｿｽT�ｿｽ�ｿｽ�ｿｽ^�ｿｽ�ｿｽ�ｿｽg�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽM�ｿｽw�ｿｽﾉ迎�ｿｽ�ｿｽ�ｿｽASQL�ｿｽﾌセ�ｿｽ�ｿｽ�ｿｽX�ｿｽ�ｿｽ�ｿｽ�ｿｽﾉ役立つ托ｿｽZ�ｿｽ�ｿｽ�ｿｽZ�ｿｽ�ｿｽ�ｿｽﾐ介し�ｿｽﾄゑｿｽ�ｿｽ�ｿｽ�ｿｽB�ｿｽi�ｿｽﾒ集�ｿｽﾇ）

�ｿｽ�ｿｽ�ｿｽﾊの集�ｿｽv�ｿｽl�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽﾟゑｿｽ

�ｿｽ@�ｿｽ�ｿｽ�ｿｽ�ｿｽﾍ集�ｿｽv�ｿｽ�ｿｽ�ｿｽﾉ使�ｿｽp�ｿｽ�ｿｽ�ｿｽ�ｿｽﾆ便暦ｿｽ�ｿｽﾈ関撰ｿｽ�ｿｽﾉタ�ｿｽ[�ｿｽQ�ｿｽb�ｿｽg�ｿｽ�ｿｽ�ｿｽi�ｿｽ�ｿｽ�ｿｽﾄ会ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽﾜゑｿｽ�ｿｽB�ｿｽW�ｿｽv�ｿｽ�ｿｽ�ｿｽﾉ使�ｿｽp�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽﾖ撰ｿｽ�ｿｽﾉゑｿｽ

�ｿｽﾈどゑｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽﾜゑｿｽ�ｿｽB�ｿｽ痰ｦ�ｿｽﾎ、�ｿｽ�ｿｽ�ｿｽX�ｿｽg1�ｿｽﾌサ�ｿｽ�ｿｽ�ｿｽv�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ繧ｰ�ｿｽ\�ｿｽ�ｿｽ�ｿｽ迪趣ｿｽﾊの費ｿｽ�ｿｽ�ｿｽ繧ｰ�ｿｽW�ｿｽv�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽﾟてみまゑｿｽ�ｿｽ蛯､�ｿｽB

SQL> desc sales
�ｿｽ�ｿｽ�ｿｽO                                      �ｿｽ^
----------------------------------------- -------------------
PRODUCT_CODE                              NUMBER
MONTH                                     NUMBER
SAL                                       NUMBER

SQL> select month,sum(sal) from sales group by month order by 1;
     MONTH   SUM(SAL)
---------- ----------
         1      50000
         2     107200
         3     160800
         4      80400
         5     100500
         6     120600
         7      93800
         8     107200
         9     120600
        10     134000
        11     147400
        12     160800

�ｿｽ@�ｿｽﾈ単�ｿｽﾅゑｿｽ�ｿｽﾋ。�ｿｽﾅは四�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽﾊの費ｿｽ�ｿｽ�ｿｽ繧ｰ�ｿｽW�ｿｽv�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽﾟゑｿｽﾉは、�ｿｽﾇゑｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽﾎよい�ｿｽﾅゑｿｽ�ｿｽ蛯､�ｿｽB

�ｿｽl�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽﾊの集�ｿｽv�ｿｽl�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽﾟゑｿｽiUNION ALL�ｿｽﾒ）

�ｿｽ@�ｿｽﾜゑｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽﾎゑｿｽﾈ単�ｿｽﾈのは“UNION ALL�ｿｽh�ｿｽﾅ連�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽﾄゑｿｽ�ｿｽﾜゑｿｽ�ｿｽ�ｿｽ�ｿｽ@�ｿｽﾅはなゑｿｽ�ｿｽﾅゑｿｽ�ｿｽ蛯､�ｿｽ�ｿｽ�ｿｽBUNION ALL�ｿｽ�ｿｽ2�ｿｽﾂ以擾ｿｽﾌク�ｿｽG�ｿｽ�ｿｽ�ｿｽﾌ鯉ｿｽ�ｿｽﾊゑｿｽA�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽW�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽZ�ｿｽq�ｿｽﾅゑｿｽ�ｿｽB

SQL> select '1Q' quarter,sum(sal) from sales
     where month between 1 and 3
       union all
     select '2Q' quarter,sum(sal) from sales
     where month between 4 and 6
       union all
     select '3Q' quarter,sum(sal) from sales
     where month between 7 and 9
       union all
     select '4Q' quarter,sum(sal) from sales
     where month between 10 and 12;
QUARTER   SUM(SAL)
------- ----------
1Q          318000
2Q          301500
3Q          321600
4Q          442200

�ｿｽ@�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽA�ｿｽ�ｿｽ�ｿｽﾌ場合�ｿｽ�ｿｽ�ｿｽ�ｿｽSALES�ｿｽ\�ｿｽ�ｿｽ4�ｿｽ�ｿｽA�ｿｽN�ｿｽZ�ｿｽX�ｿｽ�ｿｽ�ｿｽﾄゑｿｽ�ｿｽﾜゑｿｽ�ｿｽﾌで、�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽSQL�ｿｽ�ｿｽ�ｿｽﾆなゑｿｽ�ｿｽﾄゑｿｽ�ｿｽﾜゑｿｽ�ｿｽB�ｿｽp�ｿｽt�ｿｽH�ｿｽ[�ｿｽ}�ｿｽ�ｿｽ�ｿｽX�ｿｽ�ｿｽ�ｿｽ�ｿｽﾉなるか�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽﾜゑｿｽ�ｿｽ�ｿｽB�ｿｽi�ｿｽ�ｿｽ�ｿｽy�ｿｽ[�ｿｽW�ｿｽﾖ托ｿｽ�ｿｽ�ｿｽ�ｿｽj