求解sql语句

如何使用oracle的cube/rollup运算符得到以下结果SHELF  FRAME  WITHIN  MOSS_NO  PRODUCTCODE   COUNT
01     02     18      SH2-34   EBWT          1
02     05     35      GGZ-36   CWAT          1
03     15     24      GGZ-36   RER           1得到结果SHELF  FRAME  WITHIN  MOSS_NO  PRODUCTCODE   COUNT
01     02     18      SH2-34   EBWT          1
小计                                               1
02      05     35      GGZ-36   CWAT         1
小计                                               1
03     15     24      GGZ-36   RER           1
小计                                               1
合计                                               3