这是我的SQL语句:
SELECT * FROM
(SELECT SUM(DECODE(ACCIDENT_TYPE,'1',1,0)) TYPE1,SUM(DECODE(ACCIDENT_TYPE,'1',NUM,0)) TYPE1NUM,
SUM(DECODE(ACCIDENT_TYPE,'2',1,0)) TYPE2,SUM(DECODE(ACCIDENT_TYPE,'2',NUM,0)) TYPE2NUM,
SUM(DECODE(ACCIDENT_TYPE,'3',1,0)) TYPE3,SUM(DECODE(ACCIDENT_TYPE,'3',NUM,0)) TYPE3NUM
FROM
(SELECT ACCIDENT_TYPE,NVL(DEATH_TOLL,0)+NVL(DEATH_TOLL_OUTER,0)+NVL(X_DEATH_TOLL_OUTER,0) NUM FROM C_ACCIDENT_GEN_MAIN_TB
WHERE TO_CHAR(OCCURRED_DATE,'YYYY') = TO_CHAR(SYSDATE,'YYYY'))
WHERE NUM>0),
(SELECT * FROM C_ACCIDENT_RATE_V)
截图如下:

现在我需要把这一行结果拆成两行,一行显示数字的,一行显示上涨的,请问怎么做
------解决思路----------------------
使用union all