{"id":2018,"date":"2012-04-21T13:27:21","date_gmt":"2012-04-21T13:27:21","guid":{"rendered":"http:\/\/enjoyasp.net\/?p=2018"},"modified":"2012-04-21T13:29:08","modified_gmt":"2012-04-21T13:29:08","slug":"%e4%b9%98%e7%a7%af%e8%81%9a%e5%90%88%e5%87%bd%e6%95%b0","status":"publish","type":"post","link":"https:\/\/enjoyasp.net\/index.php\/2012\/04\/21\/%e4%b9%98%e7%a7%af%e8%81%9a%e5%90%88%e5%87%bd%e6%95%b0\/","title":{"rendered":"\u4e58\u79ef\u805a\u5408\u51fd\u6570"},"content":{"rendered":"<p>MSSQL\u4e2d\u6ca1\u6709\u76f4\u63a5\u7684\u5982SUM\u4e00\u6837\u7684\u4e58\u79ef\u51fd\u6570\uff0c\u4e0d\u8fc7\u53ef\u901a\u8fc7\u53d8\u6362\u5f97\u5230\u3002<br \/>\n\u7531log(a) + log(b) + loa(c) = log(a*b*c)  \u5f97\u5230\uff1a<br \/>\na*b*c = exp(log(a) + log(b) + loa(c)) (exp:e\u7684\u6307\u6570\uff0c \u5982EXP(10) = e^10 )\uff0c<br \/>\n\u56e0log(a) + log(b) + loa(c)\u53ef\u4ee5\u901a\u8fc7\u52a0\u6cd5\u5f97\u5230\uff0c\u6545\u4e58\u79ef\u4e5f\u53ef\u5f97\u5230\u3002<\/p>\n<p>\u5982\u4e0b\uff1a<br \/>\nselect EXP(sum(LOG(quantity))) from(<br \/>\nselect 1 quantity<br \/>\nunion select 2<br \/>\nunion select 3<br \/>\nunion select 4<br \/>\nunion select 5<br \/>\n)m<\/p>\n","protected":false},"excerpt":{"rendered":"<p>MSSQL\u4e2d\u6ca1\u6709\u76f4\u63a5\u7684\u5982SUM\u4e00\u6837\u7684\u4e58\u79ef\u51fd\u6570\uff0c\u4e0d\u8fc7\u53ef\u901a\u8fc7\u53d8\u6362\u5f97\u5230\u3002 \u7531log(a) + log(b) + lo [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[36],"tags":[],"class_list":["post-2018","post","type-post","status-publish","format-standard","hentry","category-sql-server"],"blocksy_meta":[],"_links":{"self":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/posts\/2018","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/comments?post=2018"}],"version-history":[{"count":0,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/posts\/2018\/revisions"}],"wp:attachment":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/media?parent=2018"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/categories?post=2018"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/tags?post=2018"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}