Question

oracle group by rollup 排序问题

需要按第一行倒序排列，需要达到的效果是第一行为5,4,3,2,1,合计
select decode(GROUPING(r),1,'合计',r) r, SUM(r2) r2
from (select rownum r,rownum+1 r2
from dual connect by rownum<=5)
GROUP BY ROLLUP((r,r2))
--order by r desc

Answer 1

前面不变，后面加如下order by :
order by to_number(decode(r, '合计', null,r)) desc nulls last