{"id":228698,"date":"2020-12-07T19:23:50","date_gmt":"2020-12-07T11:23:50","guid":{"rendered":"http:\/\/4563.org\/?p=228698"},"modified":"2020-12-07T19:23:50","modified_gmt":"2020-12-07T11:23:50","slug":"mssql-%e8%af%ad%e5%8f%a5%e8%ae%a1%e7%ae%97%e5%80%bc%e4%b8%ba%e9%9b%b6%e3%80%82","status":"publish","type":"post","link":"http:\/\/4563.org\/?p=228698","title":{"rendered":"MSSQL \u8bed\u53e5\u8ba1\u7b97\u503c\u4e3a\u96f6\u3002"},"content":{"rendered":"<div>\n<div>\n<div>\n<h1>                  MSSQL \u8bed\u53e5\u8ba1\u7b97\u503c\u4e3a\u96f6\u3002               <\/h1>\n<p> <\/p>\n<div>\n<div> <span>\u8cc7\u6df1\u5927\u4f6c : wzsyou <\/span>  <span><i><\/i> 5<\/span> <\/div>\n<div> <\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<div isfirst=\"1\"> <\/p>\n<p>\u8ba1\u7b97\u5229\u6da6\uff0c\u6210\u672c\u90fd\u6ca1\u6709\u95ee\u9898\u3002\u8ba1\u7b97\u201c\u8ba2\u5355\u589e\u957f\u91cf\u201d \u8ba1\u7b97\u51fa\u6765\u5168\u662f\u96f6\uff0c\u5404\u8def\u5927\u795e\u8fd9\u4e2a\u662f\u4ec0\u4e48\u95ee\u9898\uff1f<\/p>\n<p>week1.\u8ba2\u5355\u91cf &#8212; \u6b63\u5e38 week2.\u8ba2\u5355\u91cf &#8212; \u6b63\u5e38 (week1.\u8ba2\u5355\u91cf-week2.\u8ba2\u5355\u91cf) &#8212; \u6b63\u5e38 (week1.\u8ba2\u5355\u91cf-week2.\u8ba2\u5355\u91cf)\/week2.\u8ba2\u5355\u91cf &#8212; \u5f02\u5e38<\/p>\n<p>SELECT week1.\u5e73\u53f0,week1.\u5e97\u94fa\u540d\u79f0,week1.\u8ba2\u5355\u91cf,week2.\u8ba2\u5355\u91cf,(week1.\u8ba2\u5355\u91cf-week2.\u8ba2\u5355\u91cf),((week1.\u8ba2\u5355\u91cf-week2.\u8ba2\u5355\u91cf)\/week2.\u8ba2\u5355\u91cf) AS \u8ba2\u5355\u589e\u957f\u91cf FROM ( SELECT \u5e73\u53f0,\u5e97\u94fa\u540d\u79f0,\u5468,\u8ba2\u5355\u91cf, \u6210\u672c,\u5b9e\u6536,\u5229\u6da6 FROM #week_profits where \u5468=1 ) week1 ,( SELECT \u5e73\u53f0,\u5e97\u94fa\u540d\u79f0,\u5468,\u8ba2\u5355\u91cf, \u6210\u672c,\u5b9e\u6536,\u5229\u6da6 FROM #week_profits where \u5468=2 ) week2<\/p>\n<\/p><\/div>\n<div> <b>\u5927\u4f6c\u6709\u8a71\u8aaa<\/b> (<span>0<\/span>)        <\/div>\n<div> <\/div>\n<\/p><\/div>\n<\/p><\/div>\n<ul>\n<li>\n","protected":false},"excerpt":{"rendered":"<p>MSSQL \u8bed\u53e5\u8ba1\u7b97\u503c\u4e3a\u96f6\u3002 \u8cc7\u6df1&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[],"tags":[],"_links":{"self":[{"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts\/228698"}],"collection":[{"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=228698"}],"version-history":[{"count":0,"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts\/228698\/revisions"}],"wp:attachment":[{"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=228698"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=228698"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=228698"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}