select DECODE(GROUPING(tt.PT_NAME), 1, '总计', tt.PT_NAME) 区域,
sum(tt.pt_initialtotal) 期初库存量,
sum(tt.pt_initialamount) 期初库存额,
sum(tt.pt_currentttotal) 当前库存量,
sum(tt.pt_currentamount) 当前库存额
from T_FIRSTPAGE_RESULTS tt
GROUP BY ROLLUP(tt.PT_NAME)
select tt.pt_name, tt.pt_initialtotal 库存量
from T_FIRSTPAGE_RESULTS tt
union all
select '总计', sum(tt.pt_initialtotal) 库存量
from T_FIRSTPAGE_RESULTS tt