Sql查询的时候queryPage failed : ORA-00923: 未找到要求的 FROM 关键字

记忆如牢_囚我终老 发布于 2016/10/14 18:05
阅读 438
收藏 0
SELECT * FROM (SELECT * FROM (SELECT recseqno,ROUND(SUM(KPI270/1000)) FTPDLPDCPCDF5ThrputAll,ROUND(DECODE(SUM(KPI308),0,NULL,SUM(KPI89)*8/KPI308),2) FTPULThrputsuccess,ROUND(SUM(KPI313/1000)) FTPTimeULGSM,ROUND(SUM(KPI259/1000)) FTPDLTimesuccess,ROUND(DECODE(SUM(KPI326),0,NULL,(SUM(KPI327)/KPI326)*100),2) HttpBrowseLoginRate,ROUND(DECODE(SUM(KPI286),0,NULL,(SUM(KPI292+KPI293+KPI294)*8)/KPI286),2) FTPRecTotal2DropULTDL,ROUND(SUM(KPI232/1000)) FTPsuccessCountDL,ROUND(DECODE(SUM(KPI258),0,NULL,SUM(KPI264)/KPI258)*100),2) FTPTimeRatioDLGSM,ROUND(SUM(KPI320/1000)) FTPULPDCPCDF5Thrputsuccess,ROUND(DECODE(SUM(KPI307),0,NULL,SUM(KPI313/KPI307)*100),2) FTPTimeRatioULGSM,ROUND(SUM(KPI279/1000)) FTPAttemptCountULTDS,ROUND(DECODE(SUM(KPI229),0,NULL,SUM(KPI233/KPI229)*100),2) FTPsuccessRateDLTDL,ROUND(DECODE(SUM(KPI755),0,NULL,(SUM(KPI269)/KPI755)*100),2) FTPDLLThrputRatio,ROUND(DECODE(SUM(KPI230),0,NULL,SUM(KPI234/KPI230)*100),2) FTPsuccessRateDLTDS,ROUND(SUM((KPI289+KPI290+KPI291)/1000)) FTPRecvTotalUL,ROUND(SUM(KPI278/1000)) FTPAttemptCountULTDL,ROUND(DECODE(SUM(KPI328),0,NULL,SUM(KPI330)/KPI328),2) HttpBrowseSuccessTime,ROUND(DECODE(SUM(KPI229),0,NULL,SUM(KPI237/KPI229)*100),2) FTPDropRateDLTDL,ROUND(DECODE(SUM(KPI285),0,NULL,(SUM(KPI289+KPI290+KPI291)*8)/KPI285),2) FTPRecTotal2DropUL,ROUND(DECODE(SUM(KPI228),0,NULL,SUM(KPI224/1000)),2) LTEPHYThroughputDLAll,ROUND(DECODE(SUM(KPI228+KPI277),0,NULL,SUM(KPI236+KPI285)/SUM(KPI228+KPI277)*100),2) ToTalDropRate,ROUND(DECODE(SUM(KPI230),0,NULL,SUM(KPI238/KPI230)*100),2) FTPDropRateDLTDS,ROUND(DECODE(SUM(KPI238),0,NULL,(SUM(KPI246+KPI247+KPI248+KPI249+KPI250+KPI251+KPI252+KPI253+KPI254)*8)/KPI238),2) FTPRecTotal2DropDLTDS,ROUND(SUM(KPI339/1000)) StreamAttemptCount,ROUND(DECODE(SUM(KPI236),0,NULL,(SUM(KPI240+KPI241+KPI242)*8)/KPI236),2) FTPRecTotal2DropDL,ROUND(DECODE(SUM(KPI337),0,NULL,SUM(KPI335)/KPI337),2) HttpDLThrputAll,ROUND(DECODE(SUM(KPI511),0,NULL,SUM(KPI292+KPI293+KPI294)/KPI413),2) FTPULThrputPerRBAll,ROUND(DECODE(SUM(KPI333),0,NULL,(SUM(KPI334)/KPI333)*100),2) HttpDLDropRate,ROUND(SUM(KPI237/1000)) FTPDropCountDLTDL,ROUND(DECODE(SUM(KPI264),0,NULL,SUM(KPI255+KPI256+KPI257)*8/KPI264),2) FTPDLThrputALLGSM,ROUND(DECODE(SUM(KPI237),0,NULL,(SUM(KPI243+KPI244+KPI245)*8)/KPI237),2) FTPRecTotal2DropDLTDL,ROUND(DECODE(SUM(KPI327),0,NULL,(SUM(KPI328)/KPI327)*100),2) HttpBrowseSuccessRate,ROUND(SUM(KPI231/1000)) FTPAttemptCountDLGSM,ROUND(SUM(KPI238/1000)) FTPDropCountDLTDS,ROUND(DECODE(SUM(KPI259),0,NULL,SUM(KPI240)*8/KPI259),2) FTPDLThrputsuccess,ROUND(SUM(KPI325/1000)) FTPULPHYThrputMax,ROUND(DECODE(SUM(KPI338),0,NULL,SUM(KPI336)/KPI338),2) HttpDLThrputSuccess,ROUND(DECODE(SUM(KPI313),0,NULL,SUM(KPI304+KPI305+KPI306)*8/KPI313),2) FTPULThrputALLGSM,ROUND(DECODE(SUM(KPI340),0,NULL,SUM(KPI343)/KPI340),2) StreamPlayTimeTotal,ROUND(SUM(KPI262/1000)) FTPTimeDLTDS,ROUND(DECODE(SUM(KPI307),0,NULL,SUM(KPI309/KPI307)*100),2) FTPTimeRatioULTDL,ROUND(DECODE(SUM(KPI344),0,NULL,SUM(KPI345)/KPI344),2) StreamPauseTime,ROUND(SUM(KPI229/1000)) FTPAttemptCountDLTDL,ROUND(SUM(KPI286/1000)) FTPDropCountULTDL,ROUND(SUM(KPI230/1000)) FTPAttemptCountDLTDS,ROUND(DECODE(SUM(KPI263),0,NULL,SUM(KPI246+KPI249+KPI252)*8/KPI263),2) FTPDLThrputsuccessTDS,ROUND(DECODE(SUM(KPI261),0,NULL,SUM(KPI243)*8/KPI261),2) FTPDLThrputsuccessTDL,ROUND(SUM(KPI260/1000)) FTPTimeDLTDL,ROUND(DECODE(SUM(KPI228),0,NULL,SUM(KPI236/KPI228)*100),2) FTPDropRateDL,ROUND(SUM(KPI319/1000)) FTPULPDCPCDF5ThrputAll,ROUND(DECODE(SUM(KPI757),0,NULL,SUM(KPI292)/KPI757),2) FTPULThrputPerRBsuccess,ROUND(SUM(KPI287/1000)) FTPDropCountULTDS,ROUND(SUM(KPI239/1000)) FTPDropCountDLGSM,ROUND(DECODE(SUM(KPI327),0,NULL,SUM(KPI329)/KPI327),2) HttpBrowseLoginDelay,ROUND(DECODE(SUM(KPI279),0,NULL,SUM(KPI283/KPI279)*100),2) FTPsuccessRateULTDS,ROUND(SUM(KPI236/1000)) FTPDropCountDL,ROUND(DECODE(SUM(KPI307),0,NULL,SUM(KPI311/KPI307)*100),2) FTPTimeRatioULTDS,ROUND(SUM(KPI240/1000)) FTPRecvTotalsuccessDL,ROUND(DECODE(SUM(KPI278),0,NULL,SUM(KPI282/KPI278)*100),2) FTPsuccessRateULTDL,ROUND(DECODE(SUM(KPI340),0,NULL,(SUM(KPI339)/KPI340)*100),2) StreamSuccessRate,ROUND(DECODE(SUM(KPI277),0,NULL,SUM(KPI285/KPI277)*100),2) FTPDropRateUL,ROUND(DECODE(SUM(KPI340),0,NULL,SUM(KPI343-KPI342-KPI341)/KPI340),2) StreamFileTime,ROUND(SUM(KPI285/1000)) FTPDropCountUL,ROUND(SUM((KPI240+KPI241+KPI242)/1000)) FTPRecvTotalDL,ROUND(DECODE(SUM(KPI239),0,NULL,(SUM(KPI255+KPI256+KPI257)*8)/KPI239),2) FTPRecTotal2DropDLGSM,ROUND(DECODE(SUM(KPI330),0,NULL,SUM(KPI331)/KPI330),2) HttpBrowseDLThrput,ROUND(SUM(KPI326/1000)) HttpBrowseAttemptCount,ROUND(SUM((KPI289)/1000)) FTPRecvTotalsuccessUL,ROUND(DECODE(SUM(KPI346),0,NULL,SUM(KPI347)/KPI346),2) StreamDLThrputSuccess,ROUND(SUM(KPI234/1000)) FTPsuccessCountDLTDS,ROUND(DECODE(SUM(KPI287),0,NULL,(SUM(KPI295+KPI296+KPI297+KPI298+KPI299+KPI300+KPI301++KPI302+KPI303)*8)/KPI287),2) FTPRecTotal2DropULTDS,ROUND(DECODE(SUM(KPI758),0,NULL,SUM(KPI341)/KPI758),2) StreamRealPlayDelay,ROUND(SUM(KPI233/1000)) FTPsuccessCountDLTDL,ROUND(SUM(KPI284/1000)) FTPsuccessCountULGSM,ROUND(SUM(KPI308/1000)) FTPULTimesuccess,ROUND(SUM(KPI276/1000)) FTPDLPHYThrputMax,ROUND(DECODE(SUM(KPI278),0,NULL,SUM(KPI286/KPI278)*100),2) FTPDropRateULTDL,ROUND(DECODE(SUM(KPI267),0,NULL,SUM(KPI266)/KPI267),2) FTPDLPDCPThrputAll,ROUND(DECODE(SUM(KPI280),0,NULL,SUM(KPI284/KPI280)*100),2) FTPsuccessRateULGSM,ROUND(SUM(KPI235/1000)) FTPsuccessCountDLGSM,ROUND(DECODE(SUM(KPI277),0,NULL,SUM(KPI226/1000)),2) LTEPHYThroughputULAll,ROUND(DECODE(SUM(KPI277),0,NULL,SUM(KPI281/KPI277)*100),2) FTPsuccessRateUL,ROUND(DECODE(SUM(KPI279),0,NULL,SUM(KPI287/KPI279)*100),2) FTPDropRateULTDS,ROUND(DECODE(SUM(KPI231),0,NULL,SUM(KPI235/KPI231)*100),2) FTPsuccessRateDLGSM,ROUND(DECODE(SUM(KPI280),0,NULL,SUM(KPI288/KPI280)*100),2) FTPDropRateuULGSM,ROUND(SUM(KPI271/1000)) FTPDLPDCPCDF5Thrputsuccess,ROUND(DECODE(SUM(KPI258),0,NULL,SUM(KPI260)/KPI258)*100),2) FTPTimeRatioDLTDL,ROUND(SUM(KPI322/1000)) FTPULCDF5Thrputsuccess,ROUND(SUM(KPI277/1000)) FTPAttemptCountUL,ROUND(DECODE(SUM(KPI258),0,NULL,SUM(KPI262)/KPI258)*100),2) FTPTimeRatioDLTDS,ROUND(DECODE(SUM(KPI311),0,NULL,SUM(KPI295+KPI296+KPI297+KPI298+KPI299+KPI300+KPI301++KPI302+KPI303)*8/KPI311),2) FTPULThrputALLTDS,ROUND(DECODE(SUM(KPI269),0,NULL,SUM(KPI268)/KPI269),2) FTPDLPDCPThrputsuccess,ROUND(DECODE(SUM(KPI309),0,NULL,SUM(KPI292+KPI293+KPI294)*8/KPI309),2) FTPULThrputALLTDL,ROUND(SUM(KPI228/1000)) FTPAttemptCountDL,ROUND(DECODE(SUM(KPI341),0,NULL,SUM(KPI348)/KPI341),2) StreamRealPlayThrput,ROUND(DECODE(SUM(KPI332),0,NULL,(SUM(KPI333)/KPI332)*100),2) HttpDLSuccessRate,ROUND(SUM(KPI272/1000)) FTPDLCDF5ThrputAll,ROUND(DECODE(SUM(KPI277),0,NULL,SUM(KPI227/1000)),2) LTEPHYThroughputULSuccess,ROUND(DECODE(SUM(KPI756),0,NULL,(SUM(KPI324)/KPI756)*100),2) FTPULLThrputRatio,ROUND(SUM(KPI333/1000)) HttpDLSuccessCount,ROUND(DECODE(SUM(KPI260),0,NULL,SUM(KPI243+KPI244+KPI245)*8/KPI260),2) FTPDLThrputALLTDL,ROUND(SUM(KPI334/1000)) HttpDLDropCount,ROUND(DECODE(SUM(KPI316),0,NULL,(SUM(KPI323)/KPI316)*100),2) FTPULPCDPLThrputRatio,ROUND(DECODE(SUM(KPI288),0,NULL,(SUM(KPI304+KPI305+KPI306)*8)/KPI288),2) FTPRecTotal2DropULGSM,ROUND(DECODE(SUM(KPI318),0,NULL,SUM(KPI317)/KPI318),2) FTPULPDCPThrputsuccess,ROUND(SUM(KPI273/1000)) FTPDLCDF5Thrputsuccess,ROUND(DECODE(SUM(KPI262),0,NULL,SUM(KPI246+KPI247+KPI248+KPI249+KPI250+KPI251+KPI252+KPI253+KPI254)*8/KPI262),2) FTPDLThrputALLTDS,ROUND(DECODE(SUM(KPI228),0,NULL,SUM(KPI232/KPI228)*100),2) FTPsuccessRateDL,ROUND(SUM(KPI281/1000)) FTPsuccessCountUL,ROUND(SUM(KPI332/1000)) HttpDLAttemptCount,ROUND(DECODE(SUM(KPI258),0,NULL,SUM(KPI240+KPI241+KPI242)*8/KPI258),2) FTPDLThrputALL,ROUND(SUM(KPI280/1000)) FTPAttemptCountULGSM,ROUND(SUM(KPI283/1000)) FTPsuccessCountULTDS,ROUND(DECODE(SUM(KPI314),0,NULL,SUM(KPI304)*8/KPI314),2) FTPULThrputsuccessGSM,ROUND(SUM(KPI307/1000)) FTPULTimeALL,ROUND(SUM(KPI282/1000)) FTPsuccessCountULTDL,ROUND(DECODE(SUM(KPI413),0,NULL,SUM(KPI243+KPI244+KPI245)/KPI413),2) FTPDLThrputPerRBAll,ROUND(DECODE(SUM(KPI307),0,NULL,SUM(KPI289+KPI290+KPI291)*8/KPI307),2) FTPULThrputALL,ROUND(SUM(KPI258/1000)) FTPDLTimeALL,ROUND(SUM(KPI327/1000)) HttpBrowseLoginCount,ROUND(DECODE(SUM(KPI228),0,NULL,SUM(KPI225/1000)),2) LTEPHYThroughputDLSuccess,ROUND(DECODE(SUM(KPI754),0,NULL,SUM(KPI243)/KPI754),2) FTPDLThrputPerRBsuccess,ROUND(SUM(KPI340/1000)) StreamSuccessCount,ROUND(DECODE(SUM(KPI343-KPI342-KPI341),0,NULL,(SUM(KPI343)/SUM(KPI343-KPI342-KPI341)-1)*100),2) StreamPlayOvertimeRate,ROUND(SUM(KPI288/1000)) FTPDropCountULGSM,ROUND(SUM(KPI321/1000)) FTPULCDF5ThrputAll,ROUND(SUM(KPI264/1000)) FTPTimeDLGSM,ROUND(SUM(KPI344/1000)) StreamPauseCount,ROUND(DECODE(SUM(KPI316),0,NULL,SUM(KPI315)/KPI316),2) FTPULPDCPThrputAll,ROUND(DECODE(SUM(KPI310),0,NULL,SUM(KPI292)*8/KPI310),2) FTPULThrputsuccessTDL,ROUND(SUM(KPI311/1000)) FTPTimeULTDS,ROUND(SUM(KPI328/1000)) HttpBrowseSuccessCount,ROUND(DECODE(SUM(KPI312),0,NULL,SUM(KPI295+KPI298+KPI301)*8/KPI312),2) FTPULThrputsuccessTDS,ROUND(DECODE(SUM(KPI267),0,NULL,(SUM(KPI274)/KPI267)*100),2) FTPDLPCDPLThrputRatio,ROUND(DECODE(SUM(KPI265),0,NULL,SUM(KPI243)*8/KPI265),2) FTPDLThrputsuccessGSM,ROUND(SUM(KPI309/1000)) FTPTimeULTDL,ROUND(DECODE(SUM(KPI231),0,NULL,SUM(KPI239/KPI231)*100),2) FTPDropRateDLGSM FROM IADS_ADT_LTE_DATA WHERE 1=1 and  recseqno in(207)  GROUP BY recseqno UNION SELECT NULL AS recseqno,ROUND(SUM(KPI270/1000)) FTPDLPDCPCDF5ThrputAll,ROUND(DECODE(SUM(KPI308),0,NULL,SUM(KPI89)*8/KPI308),2) FTPULThrputsuccess,ROUND(SUM(KPI313/1000)) FTPTimeULGSM,ROUND(SUM(KPI259/1000)) FTPDLTimesuccess,ROUND(DECODE(SUM(KPI326),0,NULL,(SUM(KPI327)/KPI326)*100),2) HttpBrowseLoginRate,ROUND(DECODE(SUM(KPI286),0,NULL,(SUM(KPI292+KPI293+KPI294)*8)/KPI286),2) FTPRecTotal2DropULTDL,ROUND(SUM(KPI232/1000)) FTPsuccessCountDL,ROUND(DECODE(SUM(KPI258),0,NULL,SUM(KPI264)/KPI258)*100),2) FTPTimeRatioDLGSM,ROUND(SUM(KPI320/1000)) FTPULPDCPCDF5Thrputsuccess,ROUND(DECODE(SUM(KPI307),0,NULL,SUM(KPI313/KPI307)*100),2) FTPTimeRatioULGSM,ROUND(SUM(KPI279/1000)) FTPAttemptCountULTDS,ROUND(DECODE(SUM(KPI229),0,NULL,SUM(KPI233/KPI229)*100),2) FTPsuccessRateDLTDL,ROUND(DECODE(SUM(KPI755),0,NULL,(SUM(KPI269)/KPI755)*100),2) FTPDLLThrputRatio,ROUND(DECODE(SUM(KPI230),0,NULL,SUM(KPI234/KPI230)*100),2) FTPsuccessRateDLTDS,ROUND(SUM((KPI289+KPI290+KPI291)/1000)) FTPRecvTotalUL,ROUND(SUM(KPI278/1000)) FTPAttemptCountULTDL,ROUND(DECODE(SUM(KPI328),0,NULL,SUM(KPI330)/KPI328),2) HttpBrowseSuccessTime,ROUND(DECODE(SUM(KPI229),0,NULL,SUM(KPI237/KPI229)*100),2) FTPDropRateDLTDL,ROUND(DECODE(SUM(KPI285),0,NULL,(SUM(KPI289+KPI290+KPI291)*8)/KPI285),2) FTPRecTotal2DropUL,ROUND(DECODE(SUM(KPI228),0,NULL,SUM(KPI224/1000)),2) LTEPHYThroughputDLAll,ROUND(DECODE(SUM(KPI228+KPI277),0,NULL,SUM(KPI236+KPI285)/SUM(KPI228+KPI277)*100),2) ToTalDropRate,ROUND(DECODE(SUM(KPI230),0,NULL,SUM(KPI238/KPI230)*100),2) FTPDropRateDLTDS,ROUND(DECODE(SUM(KPI238),0,NULL,(SUM(KPI246+KPI247+KPI248+KPI249+KPI250+KPI251+KPI252+KPI253+KPI254)*8)/KPI238),2) FTPRecTotal2DropDLTDS,ROUND(SUM(KPI339/1000)) StreamAttemptCount,ROUND(DECODE(SUM(KPI236),0,NULL,(SUM(KPI240+KPI241+KPI242)*8)/KPI236),2) FTPRecTotal2DropDL,ROUND(DECODE(SUM(KPI337),0,NULL,SUM(KPI335)/KPI337),2) HttpDLThrputAll,ROUND(DECODE(SUM(KPI511),0,NULL,SUM(KPI292+KPI293+KPI294)/KPI413),2) FTPULThrputPerRBAll,ROUND(DECODE(SUM(KPI333),0,NULL,(SUM(KPI334)/KPI333)*100),2) HttpDLDropRate,ROUND(SUM(KPI237/1000)) FTPDropCountDLTDL,ROUND(DECODE(SUM(KPI264),0,NULL,SUM(KPI255+KPI256+KPI257)*8/KPI264),2) FTPDLThrputALLGSM,ROUND(DECODE(SUM(KPI237),0,NULL,(SUM(KPI243+KPI244+KPI245)*8)/KPI237),2) FTPRecTotal2DropDLTDL,ROUND(DECODE(SUM(KPI327),0,NULL,(SUM(KPI328)/KPI327)*100),2) HttpBrowseSuccessRate,ROUND(SUM(KPI231/1000)) FTPAttemptCountDLGSM,ROUND(SUM(KPI238/1000)) FTPDropCountDLTDS,ROUND(DECODE(SUM(KPI259),0,NULL,SUM(KPI240)*8/KPI259),2) FTPDLThrputsuccess,ROUND(SUM(KPI325/1000)) FTPULPHYThrputMax,ROUND(DECODE(SUM(KPI338),0,NULL,SUM(KPI336)/KPI338),2) HttpDLThrputSuccess,ROUND(DECODE(SUM(KPI313),0,NULL,SUM(KPI304+KPI305+KPI306)*8/KPI313),2) FTPULThrputALLGSM,ROUND(DECODE(SUM(KPI340),0,NULL,SUM(KPI343)/KPI340),2) StreamPlayTimeTotal,ROUND(SUM(KPI262/1000)) FTPTimeDLTDS,ROUND(DECODE(SUM(KPI307),0,NULL,SUM(KPI309/KPI307)*100),2) FTPTimeRatioULTDL,ROUND(DECODE(SUM(KPI344),0,NULL,SUM(KPI345)/KPI344),2) StreamPauseTime,ROUND(SUM(KPI229/1000)) FTPAttemptCountDLTDL,ROUND(SUM(KPI286/1000)) FTPDropCountULTDL,ROUND(SUM(KPI230/1000)) FTPAttemptCountDLTDS,ROUND(DECODE(SUM(KPI263),0,NULL,SUM(KPI246+KPI249+KPI252)*8/KPI263),2) FTPDLThrputsuccessTDS,ROUND(DECODE(SUM(KPI261),0,NULL,SUM(KPI243)*8/KPI261),2) FTPDLThrputsuccessTDL,ROUND(SUM(KPI260/1000)) FTPTimeDLTDL,ROUND(DECODE(SUM(KPI228),0,NULL,SUM(KPI236/KPI228)*100),2) FTPDropRateDL,ROUND(SUM(KPI319/1000)) FTPULPDCPCDF5ThrputAll,ROUND(DECODE(SUM(KPI757),0,NULL,SUM(KPI292)/KPI757),2) FTPULThrputPerRBsuccess,ROUND(SUM(KPI287/1000)) FTPDropCountULTDS,ROUND(SUM(KPI239/1000)) FTPDropCountDLGSM,ROUND(DECODE(SUM(KPI327),0,NULL,SUM(KPI329)/KPI327),2) HttpBrowseLoginDelay,ROUND(DECODE(SUM(KPI279),0,NULL,SUM(KPI283/KPI279)*100),2) FTPsuccessRateULTDS,ROUND(SUM(KPI236/1000)) FTPDropCountDL,ROUND(DECODE(SUM(KPI307),0,NULL,SUM(KPI311/KPI307)*100),2) FTPTimeRatioULTDS,ROUND(SUM(KPI240/1000)) FTPRecvTotalsuccessDL,ROUND(DECODE(SUM(KPI278),0,NULL,SUM(KPI282/KPI278)*100),2) FTPsuccessRateULTDL,ROUND(DECODE(SUM(KPI340),0,NULL,(SUM(KPI339)/KPI340)*100),2) StreamSuccessRate,ROUND(DECODE(SUM(KPI277),0,NULL,SUM(KPI285/KPI277)*100),2) FTPDropRateUL,ROUND(DECODE(SUM(KPI340),0,NULL,SUM(KPI343-KPI342-KPI341)/KPI340),2) StreamFileTime,ROUND(SUM(KPI285/1000)) FTPDropCountUL,ROUND(SUM((KPI240+KPI241+KPI242)/1000)) FTPRecvTotalDL,ROUND(DECODE(SUM(KPI239),0,NULL,(SUM(KPI255+KPI256+KPI257)*8)/KPI239),2) FTPRecTotal2DropDLGSM,ROUND(DECODE(SUM(KPI330),0,NULL,SUM(KPI331)/KPI330),2) HttpBrowseDLThrput,ROUND(SUM(KPI326/1000)) HttpBrowseAttemptCount,ROUND(SUM((KPI289)/1000)) FTPRecvTotalsuccessUL,ROUND(DECODE(SUM(KPI346),0,NULL,SUM(KPI347)/KPI346),2) StreamDLThrputSuccess,ROUND(SUM(KPI234/1000)) FTPsuccessCountDLTDS,ROUND(DECODE(SUM(KPI287),0,NULL,(SUM(KPI295+KPI296+KPI297+KPI298+KPI299+KPI300+KPI301++KPI302+KPI303)*8)/KPI287),2) FTPRecTotal2DropULTDS,ROUND(DECODE(SUM(KPI758),0,NULL,SUM(KPI341)/KPI758),2) StreamRealPlayDelay,ROUND(SUM(KPI233/1000)) FTPsuccessCountDLTDL,ROUND(SUM(KPI284/1000)) FTPsuccessCountULGSM,ROUND(SUM(KPI308/1000)) FTPULTimesuccess,ROUND(SUM(KPI276/1000)) FTPDLPHYThrputMax,ROUND(DECODE(SUM(KPI278),0,NULL,SUM(KPI286/KPI278)*100),2) FTPDropRateULTDL,ROUND(DECODE(SUM(KPI267),0,NULL,SUM(KPI266)/KPI267),2) FTPDLPDCPThrputAll,ROUND(DECODE(SUM(KPI280),0,NULL,SUM(KPI284/KPI280)*100),2) FTPsuccessRateULGSM,ROUND(SUM(KPI235/1000)) FTPsuccessCountDLGSM,ROUND(DECODE(SUM(KPI277),0,NULL,SUM(KPI226/1000)),2) LTEPHYThroughputULAll,ROUND(DECODE(SUM(KPI277),0,NULL,SUM(KPI281/KPI277)*100),2) FTPsuccessRateUL,ROUND(DECODE(SUM(KPI279),0,NULL,SUM(KPI287/KPI279)*100),2) FTPDropRateULTDS,ROUND(DECODE(SUM(KPI231),0,NULL,SUM(KPI235/KPI231)*100),2) FTPsuccessRateDLGSM,ROUND(DECODE(SUM(KPI280),0,NULL,SUM(KPI288/KPI280)*100),2) FTPDropRateuULGSM,ROUND(SUM(KPI271/1000)) FTPDLPDCPCDF5Thrputsuccess,ROUND(DECODE(SUM(KPI258),0,NULL,SUM(KPI260)/KPI258)*100),2) FTPTimeRatioDLTDL,ROUND(SUM(KPI322/1000)) FTPULCDF5Thrputsuccess,ROUND(SUM(KPI277/1000)) FTPAttemptCountUL,ROUND(DECODE(SUM(KPI258),0,NULL,SUM(KPI262)/KPI258)*100),2) FTPTimeRatioDLTDS,ROUND(DECODE(SUM(KPI311),0,NULL,SUM(KPI295+KPI296+KPI297+KPI298+KPI299+KPI300+KPI301++KPI302+KPI303)*8/KPI311),2) FTPULThrputALLTDS,ROUND(DECODE(SUM(KPI269),0,NULL,SUM(KPI268)/KPI269),2) FTPDLPDCPThrputsuccess,ROUND(DECODE(SUM(KPI309),0,NULL,SUM(KPI292+KPI293+KPI294)*8/KPI309),2) FTPULThrputALLTDL,ROUND(SUM(KPI228/1000)) FTPAttemptCountDL,ROUND(DECODE(SUM(KPI341),0,NULL,SUM(KPI348)/KPI341),2) StreamRealPlayThrput,ROUND(DECODE(SUM(KPI332),0,NULL,(SUM(KPI333)/KPI332)*100),2) HttpDLSuccessRate,ROUND(SUM(KPI272/1000)) FTPDLCDF5ThrputAll,ROUND(DECODE(SUM(KPI277),0,NULL,SUM(KPI227/1000)),2) LTEPHYThroughputULSuccess,ROUND(DECODE(SUM(KPI756),0,NULL,(SUM(KPI324)/KPI756)*100),2) FTPULLThrputRatio,ROUND(SUM(KPI333/1000)) HttpDLSuccessCount,ROUND(DECODE(SUM(KPI260),0,NULL,SUM(KPI243+KPI244+KPI245)*8/KPI260),2) FTPDLThrputALLTDL,ROUND(SUM(KPI334/1000)) HttpDLDropCount,ROUND(DECODE(SUM(KPI316),0,NULL,(SUM(KPI323)/KPI316)*100),2) FTPULPCDPLThrputRatio,ROUND(DECODE(SUM(KPI288),0,NULL,(SUM(KPI304+KPI305+KPI306)*8)/KPI288),2) FTPRecTotal2DropULGSM,ROUND(DECODE(SUM(KPI318),0,NULL,SUM(KPI317)/KPI318),2) FTPULPDCPThrputsuccess,ROUND(SUM(KPI273/1000)) FTPDLCDF5Thrputsuccess,ROUND(DECODE(SUM(KPI262),0,NULL,SUM(KPI246+KPI247+KPI248+KPI249+KPI250+KPI251+KPI252+KPI253+KPI254)*8/KPI262),2) FTPDLThrputALLTDS,ROUND(DECODE(SUM(KPI228),0,NULL,SUM(KPI232/KPI228)*100),2) FTPsuccessRateDL,ROUND(SUM(KPI281/1000)) FTPsuccessCountUL,ROUND(SUM(KPI332/1000)) HttpDLAttemptCount,ROUND(DECODE(SUM(KPI258),0,NULL,SUM(KPI240+KPI241+KPI242)*8/KPI258),2) FTPDLThrputALL,ROUND(SUM(KPI280/1000)) FTPAttemptCountULGSM,ROUND(SUM(KPI283/1000)) FTPsuccessCountULTDS,ROUND(DECODE(SUM(KPI314),0,NULL,SUM(KPI304)*8/KPI314),2) FTPULThrputsuccessGSM,ROUND(SUM(KPI307/1000)) FTPULTimeALL,ROUND(SUM(KPI282/1000)) FTPsuccessCountULTDL,ROUND(DECODE(SUM(KPI413),0,NULL,SUM(KPI243+KPI244+KPI245)/KPI413),2) FTPDLThrputPerRBAll,ROUND(DECODE(SUM(KPI307),0,NULL,SUM(KPI289+KPI290+KPI291)*8/KPI307),2) FTPULThrputALL,ROUND(SUM(KPI258/1000)) FTPDLTimeALL,ROUND(SUM(KPI327/1000)) HttpBrowseLoginCount,ROUND(DECODE(SUM(KPI228),0,NULL,SUM(KPI225/1000)),2) LTEPHYThroughputDLSuccess,ROUND(DECODE(SUM(KPI754),0,NULL,SUM(KPI243)/KPI754),2) FTPDLThrputPerRBsuccess,ROUND(SUM(KPI340/1000)) StreamSuccessCount,ROUND(DECODE(SUM(KPI343-KPI342-KPI341),0,NULL,(SUM(KPI343)/SUM(KPI343-KPI342-KPI341)-1)*100),2) StreamPlayOvertimeRate,ROUND(SUM(KPI288/1000)) FTPDropCountULGSM,ROUND(SUM(KPI321/1000)) FTPULCDF5ThrputAll,ROUND(SUM(KPI264/1000)) FTPTimeDLGSM,ROUND(SUM(KPI344/1000)) StreamPauseCount,ROUND(DECODE(SUM(KPI316),0,NULL,SUM(KPI315)/KPI316),2) FTPULPDCPThrputAll,ROUND(DECODE(SUM(KPI310),0,NULL,SUM(KPI292)*8/KPI310),2) FTPULThrputsuccessTDL,ROUND(SUM(KPI311/1000)) FTPTimeULTDS,ROUND(SUM(KPI328/1000)) HttpBrowseSuccessCount,ROUND(DECODE(SUM(KPI312),0,NULL,SUM(KPI295+KPI298+KPI301)*8/KPI312),2) FTPULThrputsuccessTDS,ROUND(DECODE(SUM(KPI267),0,NULL,(SUM(KPI274)/KPI267)*100),2) FTPDLPCDPLThrputRatio,ROUND(DECODE(SUM(KPI265),0,NULL,SUM(KPI243)*8/KPI265),2) FTPDLThrputsuccessGSM,ROUND(SUM(KPI309/1000)) FTPTimeULTDL,ROUND(DECODE(SUM(KPI231),0,NULL,SUM(KPI239/KPI231)*100),2) FTPDropRateDLGSM FROM IADS_ADT_LTE_DATA WHERE 1=1 and  recseqno in(207)  ) firstSql WHERE 1=1  ) secondSql

以下是问题补充:

@记忆如牢_囚我终老:麻烦大家看看哪儿错了,实在是找不见 (2016/10/14 18:06)
加载中
0
求是科技
求是科技

仔细看看这里,问题出现在in()

FROM IADS_ADT_LTE_DATA WHERE 1=1 and  recseqno in(207)  ) firstSql WHERE 1=1  ) secondSql

记忆如牢_囚我终老
记忆如牢_囚我终老
这个地方确定木有问题的,主要问题可能出现在了主题FROM里面,就是找不见
0
两个人-
两个人-

试一下


SELECT *
  FROM (SELECT *
          FROM (SELECT recseqno,
                       ROUND(SUM(KPI270 / 1000)) FTPDLPDCPCDF5ThrputAll,
                       ROUND(DECODE(SUM(KPI308),
                                    0,
                                    NULL,
                                    SUM(KPI89) * 8 / KPI308),
                             2) FTPULThrputsuccess,
                       ROUND(SUM(KPI313 / 1000)) FTPTimeULGSM,
                       ROUND(SUM(KPI259 / 1000)) FTPDLTimesuccess,
                       ROUND(DECODE(SUM(KPI326),
                                    0,
                                    NULL,
                                    (SUM(KPI327) / KPI326) * 100),
                             2) HttpBrowseLoginRate,
                       ROUND(DECODE(SUM(KPI286),
                                    0,
                                    NULL,
                                    (SUM(KPI292 + KPI293 + KPI294) * 8) /
                                    KPI286),
                             2) FTPRecTotal2DropULTDL,
                       ROUND(SUM(KPI232 / 1000)) FTPsuccessCountDL,
                       ROUND(DECODE(SUM(KPI258),
                                    0,
                                    NULL,
                                    SUM(KPI264 / KPI258) * 100),
                       2) FTPTimeRatioDLGSM,
               ROUND(SUM(KPI320 / 1000)) FTPULPDCPCDF5Thrputsuccess,
               ROUND(DECODE(SUM(KPI307), 0, NULL, SUM(KPI313 / KPI307) * 100),
                     2) FTPTimeRatioULGSM,
               ROUND(SUM(KPI279 / 1000)) FTPAttemptCountULTDS,
               ROUND(DECODE(SUM(KPI229), 0, NULL, SUM(KPI233 / KPI229) * 100),
                     2) FTPsuccessRateDLTDL,
               ROUND(DECODE(SUM(KPI755),
                            0,
                            NULL,
                            (SUM(KPI269) / KPI755) * 100),
                     2) FTPDLLThrputRatio,
               ROUND(DECODE(SUM(KPI230), 0, NULL, SUM(KPI234 / KPI230) * 100),
                     2) FTPsuccessRateDLTDS,
               ROUND(SUM((KPI289 + KPI290 + KPI291) / 1000)) FTPRecvTotalUL,
               ROUND(SUM(KPI278 / 1000)) FTPAttemptCountULTDL,
               ROUND(DECODE(SUM(KPI328), 0, NULL, SUM(KPI330) / KPI328), 2) HttpBrowseSuccessTime,
               ROUND(DECODE(SUM(KPI229), 0, NULL, SUM(KPI237 / KPI229) * 100),
                     2) FTPDropRateDLTDL,
               ROUND(DECODE(SUM(KPI285),
                            0,
                            NULL,
                            (SUM(KPI289 + KPI290 + KPI291) * 8) / KPI285),
                     2) FTPRecTotal2DropUL,
               ROUND(DECODE(SUM(KPI228), 0, NULL, SUM(KPI224 / 1000)), 2) LTEPHYThroughputDLAll,
               ROUND(DECODE(SUM(KPI228 + KPI277),
                            0,
                            NULL,
                            SUM(KPI236 + KPI285) / SUM(KPI228 + KPI277) * 100),
                     2) ToTalDropRate,
               ROUND(DECODE(SUM(KPI230), 0, NULL, SUM(KPI238 / KPI230) * 100),
                     2) FTPDropRateDLTDS,
               ROUND(DECODE(SUM(KPI238),
                            0,
                            NULL,
                            (SUM(KPI246 + KPI247 + KPI248 + KPI249 + KPI250 +
                                 KPI251 + KPI252 + KPI253 + KPI254) * 8) /
                            KPI238),
                     2) FTPRecTotal2DropDLTDS,
               ROUND(SUM(KPI339 / 1000)) StreamAttemptCount,
               ROUND(DECODE(SUM(KPI236),
                            0,
                            NULL,
                            (SUM(KPI240 + KPI241 + KPI242) * 8) / KPI236),
                     2) FTPRecTotal2DropDL,
               ROUND(DECODE(SUM(KPI337), 0, NULL, SUM(KPI335) / KPI337), 2) HttpDLThrputAll,
               ROUND(DECODE(SUM(KPI511),
                            0,
                            NULL,
                            SUM(KPI292 + KPI293 + KPI294) / KPI413),
                     2) FTPULThrputPerRBAll,
               ROUND(DECODE(SUM(KPI333),
                            0,
                            NULL,
                            (SUM(KPI334) / KPI333) * 100),
                     2) HttpDLDropRate,
               ROUND(SUM(KPI237 / 1000)) FTPDropCountDLTDL,
               ROUND(DECODE(SUM(KPI264),
                            0,
                            NULL,
                            SUM(KPI255 + KPI256 + KPI257) * 8 / KPI264),
                     2) FTPDLThrputALLGSM,
               ROUND(DECODE(SUM(KPI237),
                            0,
                            NULL,
                            (SUM(KPI243 + KPI244 + KPI245) * 8) / KPI237),
                     2) FTPRecTotal2DropDLTDL,
               ROUND(DECODE(SUM(KPI327),
                            0,
                            NULL,
                            (SUM(KPI328) / KPI327) * 100),
                     2) HttpBrowseSuccessRate,
               ROUND(SUM(KPI231 / 1000)) FTPAttemptCountDLGSM,
               ROUND(SUM(KPI238 / 1000)) FTPDropCountDLTDS,
               ROUND(DECODE(SUM(KPI259), 0, NULL, SUM(KPI240) * 8 / KPI259),
                     2) FTPDLThrputsuccess,
               ROUND(SUM(KPI325 / 1000)) FTPULPHYThrputMax,
               ROUND(DECODE(SUM(KPI338), 0, NULL, SUM(KPI336) / KPI338), 2) HttpDLThrputSuccess,
               ROUND(DECODE(SUM(KPI313),
                            0,
                            NULL,
                            SUM(KPI304 + KPI305 + KPI306) * 8 / KPI313),
                     2) FTPULThrputALLGSM,
               ROUND(DECODE(SUM(KPI340), 0, NULL, SUM(KPI343) / KPI340), 2) StreamPlayTimeTotal,
               ROUND(SUM(KPI262 / 1000)) FTPTimeDLTDS,
               ROUND(DECODE(SUM(KPI307), 0, NULL, SUM(KPI309 / KPI307) * 100),
                     2) FTPTimeRatioULTDL,
               ROUND(DECODE(SUM(KPI344), 0, NULL, SUM(KPI345) / KPI344), 2) StreamPauseTime,
               ROUND(SUM(KPI229 / 1000)) FTPAttemptCountDLTDL,
               ROUND(SUM(KPI286 / 1000)) FTPDropCountULTDL,
               ROUND(SUM(KPI230 / 1000)) FTPAttemptCountDLTDS,
               ROUND(DECODE(SUM(KPI263),
                            0,
                            NULL,
                            SUM(KPI246 + KPI249 + KPI252) * 8 / KPI263),
                     2) FTPDLThrputsuccessTDS,
               ROUND(DECODE(SUM(KPI261), 0, NULL, SUM(KPI243) * 8 / KPI261),
                     2) FTPDLThrputsuccessTDL,
               ROUND(SUM(KPI260 / 1000)) FTPTimeDLTDL,
               ROUND(DECODE(SUM(KPI228), 0, NULL, SUM(KPI236 / KPI228) * 100),
                     2) FTPDropRateDL,
               ROUND(SUM(KPI319 / 1000)) FTPULPDCPCDF5ThrputAll,
               ROUND(DECODE(SUM(KPI757), 0, NULL, SUM(KPI292) / KPI757), 2) FTPULThrputPerRBsuccess,
               ROUND(SUM(KPI287 / 1000)) FTPDropCountULTDS,
               ROUND(SUM(KPI239 / 1000)) FTPDropCountDLGSM,
               ROUND(DECODE(SUM(KPI327), 0, NULL, SUM(KPI329) / KPI327), 2) HttpBrowseLoginDelay,
               ROUND(DECODE(SUM(KPI279), 0, NULL, SUM(KPI283 / KPI279) * 100),
                     2) FTPsuccessRateULTDS,
               ROUND(SUM(KPI236 / 1000)) FTPDropCountDL,
               ROUND(DECODE(SUM(KPI307), 0, NULL, SUM(KPI311 / KPI307) * 100),
                     2) FTPTimeRatioULTDS,
               ROUND(SUM(KPI240 / 1000)) FTPRecvTotalsuccessDL,
               ROUND(DECODE(SUM(KPI278), 0, NULL, SUM(KPI282 / KPI278) * 100),
                     2) FTPsuccessRateULTDL,
               ROUND(DECODE(SUM(KPI340),
                            0,
                            NULL,
                            (SUM(KPI339) / KPI340) * 100),
                     2) StreamSuccessRate,
               ROUND(DECODE(SUM(KPI277), 0, NULL, SUM(KPI285 / KPI277) * 100),
                     2) FTPDropRateUL,
               ROUND(DECODE(SUM(KPI340),
                            0,
                            NULL,
                            SUM(KPI343 - KPI342 - KPI341) / KPI340),
                     2) StreamFileTime,
               ROUND(SUM(KPI285 / 1000)) FTPDropCountUL,
               ROUND(SUM((KPI240 + KPI241 + KPI242) / 1000)) FTPRecvTotalDL,
               ROUND(DECODE(SUM(KPI239),
                            0,
                            NULL,
                            (SUM(KPI255 + KPI256 + KPI257) * 8) / KPI239),
                     2) FTPRecTotal2DropDLGSM,
               ROUND(DECODE(SUM(KPI330), 0, NULL, SUM(KPI331) / KPI330), 2) HttpBrowseDLThrput,
               ROUND(SUM(KPI326 / 1000)) HttpBrowseAttemptCount,
               ROUND(SUM((KPI289) / 1000)) FTPRecvTotalsuccessUL,
               ROUND(DECODE(SUM(KPI346), 0, NULL, SUM(KPI347) / KPI346), 2) StreamDLThrputSuccess,
               ROUND(SUM(KPI234 / 1000)) FTPsuccessCountDLTDS,
               ROUND(DECODE(SUM(KPI287),
                            0,
                            NULL,
                            (SUM(KPI295 + KPI296 + KPI297 + KPI298 + KPI299 +
                                 KPI300 + KPI301 + +KPI302 + KPI303) * 8) /
                            KPI287),
                     2) FTPRecTotal2DropULTDS,
               ROUND(DECODE(SUM(KPI758), 0, NULL, SUM(KPI341) / KPI758), 2) StreamRealPlayDelay,
               ROUND(SUM(KPI233 / 1000)) FTPsuccessCountDLTDL,
               ROUND(SUM(KPI284 / 1000)) FTPsuccessCountULGSM,
               ROUND(SUM(KPI308 / 1000)) FTPULTimesuccess,
               ROUND(SUM(KPI276 / 1000)) FTPDLPHYThrputMax,
               ROUND(DECODE(SUM(KPI278), 0, NULL, SUM(KPI286 / KPI278) * 100),
                     2) FTPDropRateULTDL,
               ROUND(DECODE(SUM(KPI267), 0, NULL, SUM(KPI266) / KPI267), 2) FTPDLPDCPThrputAll,
               ROUND(DECODE(SUM(KPI280), 0, NULL, SUM(KPI284 / KPI280) * 100),
                     2) FTPsuccessRateULGSM,
               ROUND(SUM(KPI235 / 1000)) FTPsuccessCountDLGSM,
               ROUND(DECODE(SUM(KPI277), 0, NULL, SUM(KPI226 / 1000)), 2) LTEPHYThroughputULAll,
               ROUND(DECODE(SUM(KPI277), 0, NULL, SUM(KPI281 / KPI277) * 100),
                     2) FTPsuccessRateUL,
               ROUND(DECODE(SUM(KPI279), 0, NULL, SUM(KPI287 / KPI279) * 100),
                     2) FTPDropRateULTDS,
               ROUND(DECODE(SUM(KPI231), 0, NULL, SUM(KPI235 / KPI231) * 100),
                     2) FTPsuccessRateDLGSM,
               ROUND(DECODE(SUM(KPI280), 0, NULL, SUM(KPI288 / KPI280) * 100),
                     2) FTPDropRateuULGSM,
               ROUND(SUM(KPI271 / 1000)) FTPDLPDCPCDF5Thrputsuccess,
               ROUND(DECODE(SUM(KPI258), 0, NULL, SUM(KPI260 / KPI258) * 100),
               2) FTPTimeRatioDLTDL,
       ROUND(SUM(KPI322 / 1000)) FTPULCDF5Thrputsuccess,
       ROUND(SUM(KPI277 / 1000)) FTPAttemptCountUL,
       ROUND(DECODE(SUM(KPI258), 0, NULL, SUM(KPI262 / KPI258) * 100),
       2) FTPTimeRatioDLTDS, ROUND(DECODE(SUM(KPI311), 0, NULL, SUM(KPI295 + KPI296 + KPI297 + KPI298 + KPI299 + KPI300 + KPI301 + +KPI302 + KPI303) * 8 / KPI311), 2) FTPULThrputALLTDS, ROUND(DECODE(SUM(KPI269), 0, NULL, SUM(KPI268) / KPI269), 2) FTPDLPDCPThrputsuccess, ROUND(DECODE(SUM(KPI309), 0, NULL, SUM(KPI292 + KPI293 + KPI294) * 8 / KPI309), 2) FTPULThrputALLTDL, ROUND(SUM(KPI228 / 1000)) FTPAttemptCountDL, ROUND(DECODE(SUM(KPI341), 0, NULL, SUM(KPI348) / KPI341), 2) StreamRealPlayThrput, ROUND(DECODE(SUM(KPI332), 0, NULL,(SUM(KPI333) / KPI332) * 100), 2) HttpDLSuccessRate, ROUND(SUM(KPI272 / 1000)) FTPDLCDF5ThrputAll, ROUND(DECODE(SUM(KPI277), 0, NULL, SUM(KPI227 / 1000)), 2) LTEPHYThroughputULSuccess, ROUND(DECODE(SUM(KPI756), 0, NULL,(SUM(KPI324) / KPI756) * 100), 2) FTPULLThrputRatio, ROUND(SUM(KPI333 / 1000)) HttpDLSuccessCount, ROUND(DECODE(SUM(KPI260), 0, NULL, SUM(KPI243 + KPI244 + KPI245) * 8 / KPI260), 2) FTPDLThrputALLTDL, ROUND(SUM(KPI334 / 1000)) HttpDLDropCount, ROUND(DECODE(SUM(KPI316), 0, NULL,(SUM(KPI323) / KPI316) * 100), 2) FTPULPCDPLThrputRatio, ROUND(DECODE(SUM(KPI288), 0, NULL,(SUM(KPI304 + KPI305 + KPI306) * 8) / KPI288), 2) FTPRecTotal2DropULGSM, ROUND(DECODE(SUM(KPI318), 0, NULL, SUM(KPI317) / KPI318), 2) FTPULPDCPThrputsuccess, ROUND(SUM(KPI273 / 1000)) FTPDLCDF5Thrputsuccess, ROUND(DECODE(SUM(KPI262), 0, NULL, SUM(KPI246 + KPI247 + KPI248 + KPI249 + KPI250 + KPI251 + KPI252 + KPI253 + KPI254) * 8 / KPI262), 2) FTPDLThrputALLTDS, ROUND(DECODE(SUM(KPI228), 0, NULL, SUM(KPI232 / KPI228) * 100), 2) FTPsuccessRateDL, ROUND(SUM(KPI281 / 1000)) FTPsuccessCountUL, ROUND(SUM(KPI332 / 1000)) HttpDLAttemptCount, ROUND(DECODE(SUM(KPI258), 0, NULL, SUM(KPI240 + KPI241 + KPI242) * 8 / KPI258), 2) FTPDLThrputALL, ROUND(SUM(KPI280 / 1000)) FTPAttemptCountULGSM, ROUND(SUM(KPI283 / 1000)) FTPsuccessCountULTDS, ROUND(DECODE(SUM(KPI314), 0, NULL, SUM(KPI304) * 8 / KPI314), 2) FTPULThrputsuccessGSM, ROUND(SUM(KPI307 / 1000)) FTPULTimeALL, ROUND(SUM(KPI282 / 1000)) FTPsuccessCountULTDL, ROUND(DECODE(SUM(KPI413), 0, NULL, SUM(KPI243 + KPI244 + KPI245) / KPI413), 2) FTPDLThrputPerRBAll, ROUND(DECODE(SUM(KPI307), 0, NULL, SUM(KPI289 + KPI290 + KPI291) * 8 / KPI307), 2) FTPULThrputALL, ROUND(SUM(KPI258 / 1000)) FTPDLTimeALL, ROUND(SUM(KPI327 / 1000)) HttpBrowseLoginCount, ROUND(DECODE(SUM(KPI228), 0, NULL, SUM(KPI225 / 1000)), 2) LTEPHYThroughputDLSuccess, ROUND(DECODE(SUM(KPI754), 0, NULL, SUM(KPI243) / KPI754), 2) FTPDLThrputPerRBsuccess, ROUND(SUM(KPI340 / 1000)) StreamSuccessCount, ROUND(DECODE(SUM(KPI343 - KPI342 - KPI341), 0, NULL,(SUM(KPI343) / SUM(KPI343 - KPI342 - KPI341) - 1) * 100), 2) StreamPlayOvertimeRate, ROUND(SUM(KPI288 / 1000)) FTPDropCountULGSM, ROUND(SUM(KPI321 / 1000)) FTPULCDF5ThrputAll, ROUND(SUM(KPI264 / 1000)) FTPTimeDLGSM, ROUND(SUM(KPI344 / 1000)) StreamPauseCount, ROUND(DECODE(SUM(KPI316), 0, NULL, SUM(KPI315) / KPI316), 2) FTPULPDCPThrputAll, ROUND(DECODE(SUM(KPI310), 0, NULL, SUM(KPI292) * 8 / KPI310), 2) FTPULThrputsuccessTDL, ROUND(SUM(KPI311 / 1000)) FTPTimeULTDS, ROUND(SUM(KPI328 / 1000)) HttpBrowseSuccessCount, ROUND(DECODE(SUM(KPI312), 0, NULL, SUM(KPI295 + KPI298 + KPI301) * 8 / KPI312), 2) FTPULThrputsuccessTDS, ROUND(DECODE(SUM(KPI267), 0, NULL,(SUM(KPI274) / KPI267) * 100), 2) FTPDLPCDPLThrputRatio, ROUND(DECODE(SUM(KPI265), 0, NULL, SUM(KPI243) * 8 / KPI265), 2) FTPDLThrputsuccessGSM, ROUND(SUM(KPI309 / 1000)) FTPTimeULTDL, ROUND(DECODE(SUM(KPI231), 0, NULL, SUM(KPI239 / KPI231) * 100), 2) FTPDropRateDLGSM
  FROM IADS_ADT_LTE_DATA
 WHERE 1 = 1
   and recseqno in (207)
 GROUP BY recseqno
UNION
SELECT NULL AS recseqno,
       ROUND(SUM(KPI270 / 1000)) FTPDLPDCPCDF5ThrputAll,
       ROUND(DECODE(SUM(KPI308), 0, NULL, SUM(KPI89) * 8 / KPI308), 2) FTPULThrputsuccess,
       ROUND(SUM(KPI313 / 1000)) FTPTimeULGSM,
       ROUND(SUM(KPI259 / 1000)) FTPDLTimesuccess,
       ROUND(DECODE(SUM(KPI326), 0, NULL, (SUM(KPI327) / KPI326) * 100), 2) HttpBrowseLoginRate,
       ROUND(DECODE(SUM(KPI286),
                    0,
                    NULL,
                    (SUM(KPI292 + KPI293 + KPI294) * 8) / KPI286),
             2) FTPRecTotal2DropULTDL,
       ROUND(SUM(KPI232 / 1000)) FTPsuccessCountDL,
       ROUND(DECODE(SUM(KPI258), 0, NULL, SUM(KPI264 / KPI258) * 100),
       2) FTPTimeRatioDLGSM, ROUND(SUM(KPI320 / 1000)) FTPULPDCPCDF5Thrputsuccess, ROUND(DECODE(SUM(KPI307), 0, NULL, SUM(KPI313 / KPI307) * 100), 2) FTPTimeRatioULGSM, ROUND(SUM(KPI279 / 1000)) FTPAttemptCountULTDS, ROUND(DECODE(SUM(KPI229), 0, NULL, SUM(KPI233 / KPI229) * 100), 2) FTPsuccessRateDLTDL, ROUND(DECODE(SUM(KPI755), 0, NULL,(SUM(KPI269) / KPI755) * 100), 2) FTPDLLThrputRatio, ROUND(DECODE(SUM(KPI230), 0, NULL, SUM(KPI234 / KPI230) * 100), 2) FTPsuccessRateDLTDS, ROUND(SUM((KPI289 + KPI290 + KPI291) / 1000)) FTPRecvTotalUL, ROUND(SUM(KPI278 / 1000)) FTPAttemptCountULTDL, ROUND(DECODE(SUM(KPI328), 0, NULL, SUM(KPI330) / KPI328), 2) HttpBrowseSuccessTime, ROUND(DECODE(SUM(KPI229), 0, NULL, SUM(KPI237 / KPI229) * 100), 2) FTPDropRateDLTDL, ROUND(DECODE(SUM(KPI285), 0, NULL,(SUM(KPI289 + KPI290 + KPI291) * 8) / KPI285), 2) FTPRecTotal2DropUL, ROUND(DECODE(SUM(KPI228), 0, NULL, SUM(KPI224 / 1000)), 2) LTEPHYThroughputDLAll, ROUND(DECODE(SUM(KPI228 + KPI277), 0, NULL, SUM(KPI236 + KPI285) / SUM(KPI228 + KPI277) * 100), 2) ToTalDropRate, ROUND(DECODE(SUM(KPI230), 0, NULL, SUM(KPI238 / KPI230) * 100), 2) FTPDropRateDLTDS, ROUND(DECODE(SUM(KPI238), 0, NULL,(SUM(KPI246 + KPI247 + KPI248 + KPI249 + KPI250 + KPI251 + KPI252 + KPI253 + KPI254) * 8) / KPI238), 2) FTPRecTotal2DropDLTDS, ROUND(SUM(KPI339 / 1000)) StreamAttemptCount, ROUND(DECODE(SUM(KPI236), 0, NULL,(SUM(KPI240 + KPI241 + KPI242) * 8) / KPI236), 2) FTPRecTotal2DropDL, ROUND(DECODE(SUM(KPI337), 0, NULL, SUM(KPI335) / KPI337), 2) HttpDLThrputAll, ROUND(DECODE(SUM(KPI511), 0, NULL, SUM(KPI292 + KPI293 + KPI294) / KPI413), 2) FTPULThrputPerRBAll, ROUND(DECODE(SUM(KPI333), 0, NULL,(SUM(KPI334) / KPI333) * 100), 2) HttpDLDropRate, ROUND(SUM(KPI237 / 1000)) FTPDropCountDLTDL, ROUND(DECODE(SUM(KPI264), 0, NULL, SUM(KPI255 + KPI256 + KPI257) * 8 / KPI264), 2) FTPDLThrputALLGSM, ROUND(DECODE(SUM(KPI237), 0, NULL,(SUM(KPI243 + KPI244 + KPI245) * 8) / KPI237), 2) FTPRecTotal2DropDLTDL, ROUND(DECODE(SUM(KPI327), 0, NULL,(SUM(KPI328) / KPI327) * 100), 2) HttpBrowseSuccessRate, ROUND(SUM(KPI231 / 1000)) FTPAttemptCountDLGSM, ROUND(SUM(KPI238 / 1000)) FTPDropCountDLTDS, ROUND(DECODE(SUM(KPI259), 0, NULL, SUM(KPI240) * 8 / KPI259), 2) FTPDLThrputsuccess, ROUND(SUM(KPI325 / 1000)) FTPULPHYThrputMax, ROUND(DECODE(SUM(KPI338), 0, NULL, SUM(KPI336) / KPI338), 2) HttpDLThrputSuccess, ROUND(DECODE(SUM(KPI313), 0, NULL, SUM(KPI304 + KPI305 + KPI306) * 8 / KPI313), 2) FTPULThrputALLGSM, ROUND(DECODE(SUM(KPI340), 0, NULL, SUM(KPI343) / KPI340), 2) StreamPlayTimeTotal, ROUND(SUM(KPI262 / 1000)) FTPTimeDLTDS, ROUND(DECODE(SUM(KPI307), 0, NULL, SUM(KPI309 / KPI307) * 100), 2) FTPTimeRatioULTDL, ROUND(DECODE(SUM(KPI344), 0, NULL, SUM(KPI345) / KPI344), 2) StreamPauseTime, ROUND(SUM(KPI229 / 1000)) FTPAttemptCountDLTDL, ROUND(SUM(KPI286 / 1000)) FTPDropCountULTDL, ROUND(SUM(KPI230 / 1000)) FTPAttemptCountDLTDS, ROUND(DECODE(SUM(KPI263), 0, NULL, SUM(KPI246 + KPI249 + KPI252) * 8 / KPI263), 2) FTPDLThrputsuccessTDS, ROUND(DECODE(SUM(KPI261), 0, NULL, SUM(KPI243) * 8 / KPI261), 2) FTPDLThrputsuccessTDL, ROUND(SUM(KPI260 / 1000)) FTPTimeDLTDL, ROUND(DECODE(SUM(KPI228), 0, NULL, SUM(KPI236 / KPI228) * 100), 2) FTPDropRateDL, ROUND(SUM(KPI319 / 1000)) FTPULPDCPCDF5ThrputAll, ROUND(DECODE(SUM(KPI757), 0, NULL, SUM(KPI292) / KPI757), 2) FTPULThrputPerRBsuccess, ROUND(SUM(KPI287 / 1000)) FTPDropCountULTDS, ROUND(SUM(KPI239 / 1000)) FTPDropCountDLGSM, ROUND(DECODE(SUM(KPI327), 0, NULL, SUM(KPI329) / KPI327), 2) HttpBrowseLoginDelay, ROUND(DECODE(SUM(KPI279), 0, NULL, SUM(KPI283 / KPI279) * 100), 2) FTPsuccessRateULTDS, ROUND(SUM(KPI236 / 1000)) FTPDropCountDL, ROUND(DECODE(SUM(KPI307), 0, NULL, SUM(KPI311 / KPI307) * 100), 2) FTPTimeRatioULTDS, ROUND(SUM(KPI240 / 1000)) FTPRecvTotalsuccessDL, ROUND(DECODE(SUM(KPI278), 0, NULL, SUM(KPI282 / KPI278) * 100), 2) FTPsuccessRateULTDL, ROUND(DECODE(SUM(KPI340), 0, NULL,(SUM(KPI339) / KPI340) * 100), 2) StreamSuccessRate, ROUND(DECODE(SUM(KPI277), 0, NULL, SUM(KPI285 / KPI277) * 100), 2) FTPDropRateUL, ROUND(DECODE(SUM(KPI340), 0, NULL, SUM(KPI343 - KPI342 - KPI341) / KPI340), 2) StreamFileTime, ROUND(SUM(KPI285 / 1000)) FTPDropCountUL, ROUND(SUM((KPI240 + KPI241 + KPI242) / 1000)) FTPRecvTotalDL, ROUND(DECODE(SUM(KPI239), 0, NULL,(SUM(KPI255 + KPI256 + KPI257) * 8) / KPI239), 2) FTPRecTotal2DropDLGSM, ROUND(DECODE(SUM(KPI330), 0, NULL, SUM(KPI331) / KPI330), 2) HttpBrowseDLThrput, ROUND(SUM(KPI326 / 1000)) HttpBrowseAttemptCount, ROUND(SUM((KPI289) / 1000)) FTPRecvTotalsuccessUL, ROUND(DECODE(SUM(KPI346), 0, NULL, SUM(KPI347) / KPI346), 2) StreamDLThrputSuccess, ROUND(SUM(KPI234 / 1000)) FTPsuccessCountDLTDS, ROUND(DECODE(SUM(KPI287), 0, NULL,(SUM(KPI295 + KPI296 + KPI297 + KPI298 + KPI299 + KPI300 + KPI301 + +KPI302 + KPI303) * 8) / KPI287), 2) FTPRecTotal2DropULTDS, ROUND(DECODE(SUM(KPI758), 0, NULL, SUM(KPI341) / KPI758), 2) StreamRealPlayDelay, ROUND(SUM(KPI233 / 1000)) FTPsuccessCountDLTDL, ROUND(SUM(KPI284 / 1000)) FTPsuccessCountULGSM, ROUND(SUM(KPI308 / 1000)) FTPULTimesuccess, ROUND(SUM(KPI276 / 1000)) FTPDLPHYThrputMax, ROUND(DECODE(SUM(KPI278), 0, NULL, SUM(KPI286 / KPI278) * 100), 2) FTPDropRateULTDL, ROUND(DECODE(SUM(KPI267), 0, NULL, SUM(KPI266) / KPI267), 2) FTPDLPDCPThrputAll, ROUND(DECODE(SUM(KPI280), 0, NULL, SUM(KPI284 / KPI280) * 100), 2) FTPsuccessRateULGSM, ROUND(SUM(KPI235 / 1000)) FTPsuccessCountDLGSM, ROUND(DECODE(SUM(KPI277), 0, NULL, SUM(KPI226 / 1000)), 2) LTEPHYThroughputULAll, ROUND(DECODE(SUM(KPI277), 0, NULL, SUM(KPI281 / KPI277) * 100), 2) FTPsuccessRateUL, ROUND(DECODE(SUM(KPI279), 0, NULL, SUM(KPI287 / KPI279) * 100), 2) FTPDropRateULTDS, ROUND(DECODE(SUM(KPI231), 0, NULL, SUM(KPI235 / KPI231) * 100), 2) FTPsuccessRateDLGSM, ROUND(DECODE(SUM(KPI280), 0, NULL, SUM(KPI288 / KPI280) * 100), 2) FTPDropRateuULGSM, ROUND(SUM(KPI271 / 1000)) FTPDLPDCPCDF5Thrputsuccess, ROUND(DECODE(SUM(KPI258), 0, NULL, SUM(KPI260 / KPI258) * 100), 2) FTPTimeRatioDLTDL, ROUND(SUM(KPI322 / 1000)) FTPULCDF5Thrputsuccess, ROUND(SUM(KPI277 / 1000)) FTPAttemptCountUL, ROUND(DECODE(SUM(KPI258), 0, NULL, SUM(KPI262 / KPI258) * 100), 2) FTPTimeRatioDLTDS, ROUND(DECODE(SUM(KPI311), 0, NULL, SUM(KPI295 + KPI296 + KPI297 + KPI298 + KPI299 + KPI300 + KPI301 + +KPI302 + KPI303) * 8 / KPI311), 2) FTPULThrputALLTDS, ROUND(DECODE(SUM(KPI269), 0, NULL, SUM(KPI268) / KPI269), 2) FTPDLPDCPThrputsuccess, ROUND(DECODE(SUM(KPI309), 0, NULL, SUM(KPI292 + KPI293 + KPI294) * 8 / KPI309), 2) FTPULThrputALLTDL, ROUND(SUM(KPI228 / 1000)) FTPAttemptCountDL, ROUND(DECODE(SUM(KPI341), 0, NULL, SUM(KPI348) / KPI341), 2) StreamRealPlayThrput, ROUND(DECODE(SUM(KPI332), 0, NULL,(SUM(KPI333) / KPI332) * 100), 2) HttpDLSuccessRate, ROUND(SUM(KPI272 / 1000)) FTPDLCDF5ThrputAll, ROUND(DECODE(SUM(KPI277), 0, NULL, SUM(KPI227 / 1000)), 2) LTEPHYThroughputULSuccess, ROUND(DECODE(SUM(KPI756), 0, NULL,(SUM(KPI324) / KPI756) * 100), 2) FTPULLThrputRatio, ROUND(SUM(KPI333 / 1000)) HttpDLSuccessCount, ROUND(DECODE(SUM(KPI260), 0, NULL, SUM(KPI243 + KPI244 + KPI245) * 8 / KPI260), 2) FTPDLThrputALLTDL, ROUND(SUM(KPI334 / 1000)) HttpDLDropCount, ROUND(DECODE(SUM(KPI316), 0, NULL,(SUM(KPI323) / KPI316) * 100), 2) FTPULPCDPLThrputRatio, ROUND(DECODE(SUM(KPI288), 0, NULL,(SUM(KPI304 + KPI305 + KPI306) * 8) / KPI288), 2) FTPRecTotal2DropULGSM, ROUND(DECODE(SUM(KPI318), 0, NULL, SUM(KPI317) / KPI318), 2) FTPULPDCPThrputsuccess, ROUND(SUM(KPI273 / 1000)) FTPDLCDF5Thrputsuccess, ROUND(DECODE(SUM(KPI262), 0, NULL, SUM(KPI246 + KPI247 + KPI248 + KPI249 + KPI250 + KPI251 + KPI252 + KPI253 + KPI254) * 8 / KPI262), 2) FTPDLThrputALLTDS, ROUND(DECODE(SUM(KPI228), 0, NULL, SUM(KPI232 / KPI228) * 100), 2) FTPsuccessRateDL, ROUND(SUM(KPI281 / 1000)) FTPsuccessCountUL, ROUND(SUM(KPI332 / 1000)) HttpDLAttemptCount, ROUND(DECODE(SUM(KPI258), 0, NULL, SUM(KPI240 + KPI241 + KPI242) * 8 / KPI258), 2) FTPDLThrputALL, ROUND(SUM(KPI280 / 1000)) FTPAttemptCountULGSM, ROUND(SUM(KPI283 / 1000)) FTPsuccessCountULTDS, ROUND(DECODE(SUM(KPI314), 0, NULL, SUM(KPI304) * 8 / KPI314), 2) FTPULThrputsuccessGSM, ROUND(SUM(KPI307 / 1000)) FTPULTimeALL, ROUND(SUM(KPI282 / 1000)) FTPsuccessCountULTDL, ROUND(DECODE(SUM(KPI413), 0, NULL, SUM(KPI243 + KPI244 + KPI245) / KPI413), 2) FTPDLThrputPerRBAll, ROUND(DECODE(SUM(KPI307), 0, NULL, SUM(KPI289 + KPI290 + KPI291) * 8 / KPI307), 2) FTPULThrputALL, ROUND(SUM(KPI258 / 1000)) FTPDLTimeALL, ROUND(SUM(KPI327 / 1000)) HttpBrowseLoginCount, ROUND(DECODE(SUM(KPI228), 0, NULL, SUM(KPI225 / 1000)), 2) LTEPHYThroughputDLSuccess, ROUND(DECODE(SUM(KPI754), 0, NULL, SUM(KPI243) / KPI754), 2) FTPDLThrputPerRBsuccess, ROUND(SUM(KPI340 / 1000)) StreamSuccessCount, ROUND(DECODE(SUM(KPI343 - KPI342 - KPI341), 0, NULL,(SUM(KPI343) / SUM(KPI343 - KPI342 - KPI341) - 1) * 100), 2) StreamPlayOvertimeRate, ROUND(SUM(KPI288 / 1000)) FTPDropCountULGSM, ROUND(SUM(KPI321 / 1000)) FTPULCDF5ThrputAll, ROUND(SUM(KPI264 / 1000)) FTPTimeDLGSM, ROUND(SUM(KPI344 / 1000)) StreamPauseCount, ROUND(DECODE(SUM(KPI316), 0, NULL, SUM(KPI315) / KPI316), 2) FTPULPDCPThrputAll, ROUND(DECODE(SUM(KPI310), 0, NULL, SUM(KPI292) * 8 / KPI310), 2) FTPULThrputsuccessTDL, ROUND(SUM(KPI311 / 1000)) FTPTimeULTDS, ROUND(SUM(KPI328 / 1000)) HttpBrowseSuccessCount, ROUND(DECODE(SUM(KPI312), 0, NULL, SUM(KPI295 + KPI298 + KPI301) * 8 / KPI312), 2) FTPULThrputsuccessTDS, ROUND(DECODE(SUM(KPI267), 0, NULL,(SUM(KPI274) / KPI267) * 100), 2) FTPDLPCDPLThrputRatio, ROUND(DECODE(SUM(KPI265), 0, NULL, SUM(KPI243) * 8 / KPI265), 2) FTPDLThrputsuccessGSM, ROUND(SUM(KPI309 / 1000)) FTPTimeULTDL, ROUND(DECODE(SUM(KPI231), 0, NULL, SUM(KPI239 / KPI231) * 100), 2) FTPDropRateDLGSM
  FROM IADS_ADT_LTE_DATA
 WHERE 1 = 1
   and recseqno in (207)) firstSql
 WHERE 1 = 1) secondSql


返回顶部
顶部