这是我的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