{"id":55,"date":"2008-03-06T23:52:28","date_gmt":"2008-03-07T03:52:28","guid":{"rendered":"http:\/\/www.prglab.com\/blog\/p\/55"},"modified":"2008-03-14T22:31:17","modified_gmt":"2008-03-15T02:31:17","slug":"sap-abap-%e6%80%a7%e8%83%bd%e4%bc%98%e5%8c%96%e6%8a%80%e5%b7%a7-%e9%9b%86%e5%90%88%e5%87%bd%e6%95%b0","status":"publish","type":"post","link":"https:\/\/www.prglab.com\/blog\/p\/55","title":{"rendered":"SAP ABAP \u6027\u80fd\u4f18\u5316\u6280\u5de7 &#8212; \u96c6\u5408\u51fd\u6570"},"content":{"rendered":"<p class=\"MsoNormal\"><span lang=\"EN-US\"><font face=\"Arial\"><font size=\"2\">\u53ef\u4ee5\u4f7f\u7528\uff21\uff22\uff21\uff30\u63d0\u4f9b\u7684\u96c6\u5408\u51fd\u6570\u53d6\u4ee3\uff21\uff22\uff21\uff30\u4ee3\u7801\u6765\u83b7\u5f97\u6700\u5927\u6216\u6700\u5c0f\u503c\u3002<\/font><\/font><\/span><\/p>\n<p><font face=\"Arial\">\t\t\t<\/font><\/p>\n<p class=\"MsoNormal\"><span lang=\"EN-US\"><font face=\"Arial\"><font size=\"2\">\u4e0d\u5efa\u8bae\u4f7f\u7528\uff1a<\/font><\/font><\/span><\/p>\n<p><font face=\"Arial\">\t\t\t<\/font><\/p>\n<blockquote>\n<p class=\"MsoNormal\"><font color=\"#000080\"><span lang=\"EN-US\"><font face=\"Arial\"><font size=\"2\">             \t\t\tMaxnu = 0.<\/font><\/font><\/span><\/font><\/p>\n<p><font color=\"#000080\" face=\"Arial\">\t\t\t<\/font><\/p>\n<p class=\"MsoNormal\"><font color=\"#000080\"><span lang=\"EN-US\"><font face=\"Arial\"><font size=\"2\">             \t\t\tSelect * from zflight where airln = \u2018LF\u2019 and cntry = \u2018IN\u2019.<\/font><\/font><\/span><\/font><\/p>\n<p><font color=\"#000080\" face=\"Arial\">\t\t\t<\/font><\/p>\n<p class=\"MsoNormal\"><font color=\"#000080\"><span lang=\"EN-US\"><font face=\"Arial\"><font size=\"2\">\u3000\u3000Check zflight-fligh &gt; maxnu.<\/font><\/font><\/span><\/font><\/p>\n<p><font color=\"#000080\" face=\"Arial\">\t\t\t<\/font><\/p>\n<p class=\"MsoNormal\"><font color=\"#000080\"><span lang=\"EN-US\"><font face=\"Arial\"><font size=\"2\">\u3000\u3000Maxnu  \t\t\t= zflight-fligh.<\/font><\/font><\/span><\/font><\/p>\n<p><font color=\"#000080\" face=\"Arial\">\t\t\t<\/font><\/p>\n<p class=\"MsoNormal\"><font color=\"#000080\"><span lang=\"EN-US\"><font face=\"Arial\"><font size=\"2\">             \t\t\tEndselect.<\/font><\/font><\/span><\/font><\/p>\n<\/blockquote>\n<p><font color=\"#000080\" face=\"Arial\">\t\t\t<\/font> <font face=\"Arial\">\t\t\t<\/font><\/p>\n<p class=\"MsoNormal\"><span lang=\"EN-US\"><font face=\"Arial\"><font size=\"2\"> \u5efa\u8bae\u4f7f\u7528\uff1a<\/font><\/font><\/span><\/p>\n<p><font face=\"Arial\">\t\t\t<\/font><\/p>\n<blockquote>\n<p class=\"MsoNormal\"><span lang=\"EN-US\"><font face=\"Arial\"><font size=\"2\">           <font color=\"#000080\">  \t\t\tSelect max( fligh ) from zflight into maxnu where airln = \u2018LF\u2019 and  \t\t\tcntry = \u2018IN\u2019.<\/font><\/font><\/font><\/span><\/p>\n<\/blockquote>\n<p><font face=\"Arial\">\t\t\t<\/font><\/p>\n<p class=\"MsoNormal\"><span lang=\"EN-US\"><font face=\"Arial\"><font size=\"2\">\u5176\u5b83\u53ef\u7528\u96c6\u5408\u51fd\u6570\u8fd8\u6709 min (\u6700\u5c0f\u503c), avg (\u5e73\u5747\u503c), sum (\u6c42\u548c) and count (\u6570\u636e\u9009\u62e9\u7684\u884c\u6570).<\/font><\/font><\/span><\/p>\n<hr \/>\n<p> <center><font size=\"2\"><a href=\"http:\/\/www.prglab.com\/blog\/p\/53\">\u8fd4\u56de\u6587\u7ae0\u76ee\u5f55<\/a><\/font><\/center><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u53ef\u4ee5\u4f7f\u7528\uff21\uff22\uff21\uff30\u63d0\u4f9b\u7684\u96c6\u5408\u51fd\u6570\u53d6\u4ee3\uff21\uff22\uff21\uff30\u4ee3\u7801\u6765\u83b7\u5f97\u6700\u5927\u6216\u6700\u5c0f\u503c\u3002 \u4e0d\u5efa\u8bae\u4f7f\u7528\uff1a Maxnu = 0. Select * from zflight where airln = \u2018LF\u2019 and cntry = \u2018IN\u2019. \u3000\u3000Check zflight-fligh &gt; maxnu. \u3000\u3000Maxnu = zflight-fligh. Endselect. \u5efa\u8bae\u4f7f\u7528\uff1a Select max( fligh ) from zflight into maxnu where airln = \u2018LF\u2019 and cntry = \u2018IN\u2019. \u5176\u5b83\u53ef\u7528\u96c6\u5408\u51fd\u6570\u8fd8\u6709 min (\u6700\u5c0f\u503c), avg (\u5e73\u5747\u503c), sum (\u6c42\u548c) and count (\u6570\u636e\u9009\u62e9\u7684\u884c\u6570). \u8fd4\u56de\u6587\u7ae0\u76ee\u5f55<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[11],"tags":[],"_links":{"self":[{"href":"https:\/\/www.prglab.com\/blog\/wp-json\/wp\/v2\/posts\/55"}],"collection":[{"href":"https:\/\/www.prglab.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.prglab.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.prglab.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.prglab.com\/blog\/wp-json\/wp\/v2\/comments?post=55"}],"version-history":[{"count":0,"href":"https:\/\/www.prglab.com\/blog\/wp-json\/wp\/v2\/posts\/55\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.prglab.com\/blog\/wp-json\/wp\/v2\/media?parent=55"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.prglab.com\/blog\/wp-json\/wp\/v2\/categories?post=55"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.prglab.com\/blog\/wp-json\/wp\/v2\/tags?post=55"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}