以下疑惑求解,有请大虾:
以 飞茂介绍的分析函数为例:
select area_code,bill_month,sum(local_fare) local_fare
from t
group by rollup(area_code,bill_month)
输出的结果如下,
而我想得到的结果是在每个AERA_CODE内以LOCAL_FARE降序排列
应该用什么样的ORDER BY语句呢
AREA_CODE BILL_MONTH LOCAL_FARE
5761 200405 13060433.89
5761 200406 13318931.01
5761 200407 13710265.93
5761 200408 14135782.21
5761 54225413.04
5762 200405 12643792.11
5762 200406 12795060.65
5762 200407 13224298.12
5762 200408 13376468.72
5762 52039619.60
5763 200405 16649778.91
5763 200406 17120515.71
5763 200407 17487493.32
5763 200408 17928757.08
5763 69186545.02
5764 200405 12487791.94
5764 200406 13295187.67
5764 200407 13444093.76
5764 200408 13929695.09
5764 53156768.46
5765 200405 25057737.47
5765 200406 26058461.31
5765 200407 26301881.40
5765 200408 27130639.01
5765 104548719.19
333157065.31
以 飞茂介绍的分析函数为例:
select area_code,bill_month,sum(local_fare) local_fare
from t
group by rollup(area_code,bill_month)
输出的结果如下,
而我想得到的结果是在每个AERA_CODE内以LOCAL_FARE降序排列
应该用什么样的ORDER BY语句呢
![33.gif](http://www.itpub.net/images/smilies/33.gif)
AREA_CODE BILL_MONTH LOCAL_FARE
5761 200405 13060433.89
5761 200406 13318931.01
5761 200407 13710265.93
5761 200408 14135782.21
5761 54225413.04
5762 200405 12643792.11
5762 200406 12795060.65
5762 200407 13224298.12
5762 200408 13376468.72
5762 52039619.60
5763 200405 16649778.91
5763 200406 17120515.71
5763 200407 17487493.32
5763 200408 17928757.08
5763 69186545.02
5764 200405 12487791.94
5764 200406 13295187.67
5764 200407 13444093.76
5764 200408 13929695.09
5764 53156768.46
5765 200405 25057737.47
5765 200406 26058461.31
5765 200407 26301881.40
5765 200408 27130639.01
5765 104548719.19
333157065.31
![64.gif](http://www.itpub.net/images/smilies/64.gif)
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/12391917/viewspace-247737/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/12391917/viewspace-247737/