本文共 1918 字，大约阅读时间需要 6 分钟。

SELECT * FROM(SELECT CA.CATALOG_NAME,CA.CATALOG_CODE,LOGS1.APPLY_ORG_NAME,LOGS1.PROVIDE_ORG_NAME,AP.API_NAME,AP.API_URL,AP.API_ID,SUCCESS,FALL,SUM,RECENT_TIME,( CASE O.ORG_TYPE WHEN '4' THEN '市直' WHEN '3' THEN '市级' WHEN '5' THEN '县级' WHEN '6' THEN '县直' ELSE '' END ) ,(SELECT ORG_NAME FROM ORG_ORGANIZATION  OO WHERE AUTH.APPLY_ORG_ID=OO.ORG_ID) APPLY_ORG_NAME2FROM (SELECT SUM(CASE IS_SUCCESS WHEN 'Y' THEN '1' ELSE '' END) SUCCESS,(SELECT SUM(CASE IS_SUCCESS WHEN 'N' THEN '1' ELSE '' END)) FALL,(SELECT COUNT(CALL_LOGS_ID) ) SUM,(SELECT COUNT(CALL_LOGS_ID) FROM ds_api_call_logs AAA WHERE AAA.CALLED_API_ID= AP.API_ID ) countSUM,max(API_CALL_TIME) RECENT_TIME,CALL_LOGS_ID,CALLED_API_ID,PROVIDE_ORG_ID,APPLY_ORG_ID,APPLY_ORG_NAME,PROVIDE_ORG_NAME,APIKEY FROM ds_api_call_logs CLOG inner JOIN DS_API_INFO  AP ON AP.API_ID=CLOG.CALLED_API_IDGROUP BY APPLY_ORG_ID)  LOGS1 LEFT JOIN DS_API_INFO  AP ON AP.API_ID=LOGS1.CALLED_API_ID LEFT  JOIN(SELECT   SUM(1) ABC,CALLED_API_ID,CALL_LOGS_ID FROM ds_api_call_logsGROUP BY CALLED_API_ID) LOGS2 ON AP.API_ID=LOGS2.CALLED_API_ID inner JOIN DATA_SERVICE_INFO DS ON AP.SERVICE_ID=DS.SERVICE_ID  inner JOIN catalog_info CA  ON CA.CATALOG_ID=DS.CATALOG_ID LEFT JOIN ORG_ORGANIZATION  O on O.ORG_ID=LOGS1.PROVIDE_ORG_ID LEFT JOIN  DS_APPLY_AUTH AUTH ON AUTH.APIKEY=LOGS1.APIKEY)  BB INNER JOIN  (SELECT AP.API_ID,SUM(SUM) ZZZZZZZZZFROM (SELECT SUM(CASE IS_SUCCESS WHEN 'Y' THEN '1' ELSE '' END) SUCCESS,(SELECT COUNT(CALL_LOGS_ID) ) SUM,CALLED_API_ID,PROVIDE_ORG_ID,APPLY_ORG_ID,APPLY_ORG_NAME,PROVIDE_ORG_NAME,APIKEY FROM ds_api_call_logs CLOG inner JOIN DS_API_INFO  AP ON AP.API_ID=CLOG.CALLED_API_IDGROUP BY APPLY_ORG_ID)  LOGS1 inner JOIN DS_API_INFO  AP ON AP.API_ID=LOGS1.CALLED_API_ID LEFT  JOIN(SELECT   SUM(1) ABC,CALLED_API_ID,CALL_LOGS_ID FROM ds_api_call_logsGROUP BY CALLED_API_ID) LOGS2 ON AP.API_ID=LOGS2.CALLED_API_ID  GROUP BY API_ID ) ZZ ON ZZ.API_ID=BB.API_ID

转载地址：https://blog.csdn.net/qq_22041375/article/details/99763695 如侵犯您的版权，请留言回复原文章的地址，我们会给您删除此文章，给您带来不便请您谅解！