{"id":205,"date":"2015-01-14T10:51:15","date_gmt":"2015-01-14T02:51:15","guid":{"rendered":"http:\/\/www.llku.com\/?p=205"},"modified":"2015-01-14T10:54:44","modified_gmt":"2015-01-14T02:54:44","slug":"%e8%8e%b7%e5%8f%96fsg%e6%8a%a5%e8%a1%a8%e6%98%8e%e7%bb%86%e8%a1%8c%e5%ae%9a%e4%b9%89%e7%9a%84sql","status":"publish","type":"post","link":"https:\/\/www.llku.com\/?p=205","title":{"rendered":"\u83b7\u53d6FSG\u62a5\u8868\u660e\u7ec6\u884c\u5b9a\u4e49\u7684SQL"},"content":{"rendered":"<p>\n\t\u5ba2\u6237\u8981\u6c42\u53d6\u51fa\u67d0\u6307\u5b9a\u7684FSG\u62a5\u8868\u7684\u660e\u7ec6\u884c\u5b9a\u4e49\u7684\u6570\u636e\uff0c\u4ee5\u4e0b\u662f\u76f8\u5173\u7684SQL\u547d\u4ee4\uff1a\n<\/p>\n<p>\n\tSELECT *<br \/>\n\t&nbsp; FROM (SELECT RRA.NAME,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;RRV.SEQUENCE,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;RRV.DESCRIPTION,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;RRV.NUMBER_CHARACTERS_INDENTED,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;RRV.NUMBER_LINES_SKIPPED_BEFORE,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;RRV.NUMBER_LINES_SKIPPED_AFTER,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;RRV.AMOUNT_TYPE,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;RRV.UNIT_OF_MEASURE_ID,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;RRV.PARAMETER_NUM,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;RRV.PERIOD_OFFSET,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;RRV.FACTOR,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;RRV.LEVEL_OF_DETAIL,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;RRV.DISPLAY_FLAG,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;RRV.DISPLAY_ZERO_AMOUNT_FLAG,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;RRV.CHANGE_SIGN_FLAG,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;RRV.CHANGE_VARIANCE_SIGN_FLAG,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;RRV.CALCULATION_PRECEDENCE_FLAG,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;RRC.SIGN,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;RRC.LEDGER_ID,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;RRC.SEGMENT1_LOW || &#39;.&#39; || RRC.SEGMENT2_LOW || &#39;.&#39; ||<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;RRC.SEGMENT3_LOW || &#39;.&#39; || RRC.SEGMENT4_LOW || &#39;.&#39; ||<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;RRC.SEGMENT5_LOW || &#39;.&#39; || RRC.SEGMENT6_LOW || &#39;.&#39; ||<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;RRC.SEGMENT7_LOW || &#39;.&#39; || RRC.SEGMENT8_LOW SEGMENT_LOW,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;RRC.SEGMENT1_HIGH || &#39;.&#39; || RRC.SEGMENT2_HIGH || &#39;.&#39; ||<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;RRC.SEGMENT3_HIGH || &#39;.&#39; || RRC.SEGMENT4_HIGH || &#39;.&#39; ||<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;RRC.SEGMENT5_HIGH || &#39;.&#39; || RRC.SEGMENT6_HIGH || &#39;.&#39; ||<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;RRC.SEGMENT7_HIGH || &#39;.&#39; || RRC.SEGMENT8_HIGH SEGMENT_HIGH,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;RRC.SEGMENT1_TYPE || &#39;.&#39; || RRC.SEGMENT2_TYPE || &#39;.&#39; ||<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;RRC.SEGMENT3_TYPE || &#39;.&#39; || RRC.SEGMENT4_TYPE || &#39;.&#39; ||<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;RRC.SEGMENT5_TYPE || &#39;.&#39; || RRC.SEGMENT6_TYPE || &#39;.&#39; ||<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;RRC.SEGMENT7_TYPE || &#39;.&#39; || RRC.SEGMENT8_TYPE SEGMENT_HIGH_TYPE,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;RRC.RANGE_MODE,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;RRC.DR_CR_NET_CODE,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;NULL CALCULATION_SEQ,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;NULL OPERATOR,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;NULL CONSTANT,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;NULL AXIS_SEQ_LOW,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;NULL AXIS_SEQ_HIGH,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;NULL AXIS_NAME_LOW &nbsp; &nbsp; &nbsp; &nbsp;<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FROM RG_REPORT_AXIS_SETS_V &nbsp; RRA,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;RG_REPORT_AXES_V &nbsp; &nbsp; &nbsp; &nbsp;RRV,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;RG_REPORT_AXIS_CONTENTS RRC &nbsp; &nbsp; &nbsp; &nbsp;<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;WHERE 1 = 1<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;AND RRC.AXIS_SET_ID = RRA.AXIS_SET_ID<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;AND RRC.AXIS_SEQ = RRV.SEQUENCE<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;AND RRA.AXIS_SET_ID = RRV.AXIS_SET_ID<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;AND RRA.NAME IN (&#39;XXXX_\u65b0\u51c6\u5219CIRC\u7edf\u8ba1\u6307\u6807&#39;)<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; UNION ALL<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; SELECT RRA.NAME,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;RRV.SEQUENCE,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;RRV.DESCRIPTION,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;RRV.NUMBER_CHARACTERS_INDENTED,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;RRV.NUMBER_LINES_SKIPPED_BEFORE,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;RRV.NUMBER_LINES_SKIPPED_AFTER,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;RRV.AMOUNT_TYPE,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;RRV.UNIT_OF_MEASURE_ID,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;RRV.PARAMETER_NUM,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;RRV.PERIOD_OFFSET,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;RRV.FACTOR,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;RRV.LEVEL_OF_DETAIL,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;RRV.DISPLAY_FLAG,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;RRV.DISPLAY_ZERO_AMOUNT_FLAG,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;RRV.CHANGE_SIGN_FLAG,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;RRV.CHANGE_VARIANCE_SIGN_FLAG,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;RRV.CALCULATION_PRECEDENCE_FLAG,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;NULL &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;SIGN,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;NULL &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;LEDGER_ID,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;NULL &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;SEGMENT_LOW,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;NULL &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;SEGMENT_HIGH,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;NULL &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;SEGMENT_HIGH_TYPE,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;NULL &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;RANGE_MODE,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;NULL &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;DR_CR_NET_CODE,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;RRC1.CALCULATION_SEQ,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;RRC1.OPERATOR,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;RRC1.CONSTANT,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;RRC1.AXIS_SEQ_LOW,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;RRC1.AXIS_SEQ_HIGH,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;RRC1.AXIS_NAME_LOW<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FROM RG_REPORT_AXIS_SETS_V &nbsp;RRA,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;RG_REPORT_AXES_V &nbsp; &nbsp; &nbsp; RRV,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;RG_REPORT_CALCULATIONS RRC1 &nbsp; &nbsp; &nbsp; &nbsp;<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;WHERE 1 = 1<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;AND RRC1.AXIS_SET_ID = RRA.AXIS_SET_ID<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;AND RRC1.AXIS_SEQ = RRV.SEQUENCE<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;AND RRA.AXIS_SET_ID = RRV.AXIS_SET_ID<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;AND RRA.NAME IN (&#39;XXXX_\u65b0\u51c6\u5219CIRC\u7edf\u8ba1\u6307\u6807&#39;)<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; UNION ALL<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; SELECT RRA.NAME,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;RRV.SEQUENCE,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;RRV.DESCRIPTION,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;RRV.NUMBER_CHARACTERS_INDENTED,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;RRV.NUMBER_LINES_SKIPPED_BEFORE,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;RRV.NUMBER_LINES_SKIPPED_AFTER,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;RRV.AMOUNT_TYPE,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;RRV.UNIT_OF_MEASURE_ID,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;RRV.PARAMETER_NUM,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;RRV.PERIOD_OFFSET,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;RRV.FACTOR,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;RRV.LEVEL_OF_DETAIL,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;RRV.DISPLAY_FLAG,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;RRV.DISPLAY_ZERO_AMOUNT_FLAG,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;RRV.CHANGE_SIGN_FLAG,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;RRV.CHANGE_VARIANCE_SIGN_FLAG,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;RRV.CALCULATION_PRECEDENCE_FLAG,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;NULL &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;SIGN,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;NULL &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;LEDGER_ID,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;NULL &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;SEGMENT_LOW,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;NULL &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;SEGMENT_HIGH,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;NULL &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;SEGMENT_HIGH_TYPE,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;NULL &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;RANGE_MODE,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;NULL &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;DR_CR_NET_CODE,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;NULL &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;CALCULATION_SEQ,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;NULL &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;OPERATOR,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;NULL &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;CONSTANT,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;NULL &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;AXIS_SEQ_LOW,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;NULL &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;AXIS_SEQ_HIGH,<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;NULL &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;AXIS_NAME_LOW &nbsp; &nbsp; &nbsp; &nbsp;<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FROM RG_REPORT_AXIS_SETS_V RRA, RG_REPORT_AXES_V RRV &nbsp; &nbsp; &nbsp; &nbsp;<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;WHERE 1 = 1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;AND RRA.AXIS_SET_ID = RRV.AXIS_SET_ID<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;AND RRA.NAME IN (&#39;XXXX_\u65b0\u51c6\u5219CIRC\u7edf\u8ba1\u6307\u6807&#39;) &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;AND NOT EXISTS (SELECT 1<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FROM RG_REPORT_AXIS_CONTENTS T<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;WHERE T.AXIS_SET_ID = RRA.AXIS_SET_ID<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;AND T.AXIS_SEQ = RRV.SEQUENCE) &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;AND NOT EXISTS (SELECT 1<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FROM RG_REPORT_CALCULATIONS T2<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;WHERE T2.AXIS_SET_ID = RRA.AXIS_SET_ID<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;AND T2.AXIS_SEQ = RRV.SEQUENCE) &nbsp; &nbsp; &nbsp; &nbsp;<br \/>\n\t&nbsp; &nbsp; &nbsp; &nbsp; )<br \/>\n\t&nbsp;WHERE 1 = 1<br \/>\n\t&nbsp;ORDER BY NAME, SEQUENCE;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5ba2\u6237\u8981\u6c42\u53d6\u51fa\u67d0\u6307\u5b9a\u7684FSG\u62a5\u8868\u7684\u660e\u7ec6\u884c\u5b9a\u4e49\u7684\u6570\u636e\uff0c\u4ee5\u4e0b\u662f\u76f8\u5173\u7684SQL\u547d\u4ee4\uff1a SELECT * &nbsp; F &hellip; <a href=\"https:\/\/www.llku.com\/?p=205\" class=\"more-link\">\u7ee7\u7eed\u9605\u8bfb<span class=\"screen-reader-text\">\u83b7\u53d6FSG\u62a5\u8868\u660e\u7ec6\u884c\u5b9a\u4e49\u7684SQL<\/span> <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[5],"tags":[49],"_links":{"self":[{"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts\/205"}],"collection":[{"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=205"}],"version-history":[{"count":3,"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts\/205\/revisions"}],"predecessor-version":[{"id":211,"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts\/205\/revisions\/211"}],"wp:attachment":[{"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=205"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=205"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=205"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}