select B.LSH000,B.SSXH00, B.SSM000,B.SSDJMC, B.SSMC00 ,
       B.SSRQ00,B.SSSJ00,B.SSYS00,B.SSYSMC,
       B.IYS000,B.IYSMC0,B.IIYS00,B.IIYSMC,B.MZFS00,B.MZYS00,
         B.MZYSMC,B.QKYHDJ,
         decode(B.SSDJMC,'四级','4','三级','3','二级','2','一级','1') PLXH00,ID0000  from (           
SELECT a.LSH000,a.SSXH00, a.SSM000,decode(a.SSZL00,'特大','四级','大','三级','中','二级','小','一级',a.SSZL00) SSDJMC,
                            a.SSMC00,a.SSRQ00,a.SSSJ00,
                            a.SSYS00,a.SSYSMC,a.IYS000,a.IYSMC0,a.IIYS00,a.IIYSMC,a.MZFS00,a.MZYS00,
                            a.MZYSMC,a.QKYHDJ,CZRQ00,CZSJ00,SSLB00,ID0000 
                            FROM BA_BRSSXX a WHERE a.LSH000=2578729) B  order by SSXH00