{"id":375,"date":"2015-03-06T16:03:03","date_gmt":"2015-03-06T08:03:03","guid":{"rendered":"http:\/\/www.llku.com\/?p=375"},"modified":"2015-03-17T17:39:58","modified_gmt":"2015-03-17T09:39:58","slug":"%e5%88%86%e6%9c%ba%e6%9e%84%e8%8e%b7%e5%8f%96%e5%8f%91%e7%a5%a8%e4%bb%98%e6%ac%be%e9%87%91%e9%a2%9d","status":"publish","type":"post","link":"https:\/\/www.llku.com\/?p=375","title":{"rendered":"\u5206\u673a\u6784\u83b7\u53d6\u53d1\u7968\u4ed8\u6b3e\u91d1\u989d"},"content":{"rendered":"

\n\t–\u6b64\u6bb5sql\u4e3b\u8981\u662f\u7528\u6765\u83b7\u53d6“\u5206\u673a\u6784\u83b7\u53d6\u53d1\u7968\u4ed8\u6b3e\u91d1\u989d”\uff0c\u5f53\u7136\u53ef\u6839\u636e\u81ea\u5df1\u7684\u9700\u6c42\uff0c\u53d6\u51fa\u5176\u4ed6\u5b57\u6bb5\uff0c\u6bd4\u5982\u4ed8\u6b3e\u65f6\u95f4\uff0c\u5f85\u4ed8\u6b3e\u91d1\u989d\u7b49\u4fe1\u606f\n<\/p>\n

\n\tSELECT HR.NAME \u673a\u6784\u540d\u79f0, \/*AIA.INVOICE_NUM \u53d1\u7968\u53f7*\/ SUM(AIP.AMOUNT) \u91d1\u989d
\n\t FROM AP.AP_INVOICES_ALL      AIA,
\n\t       AP_INVOICE_PAYMENTS_ALL AIP,
\n\t       HR_OPERATING_UNITS      HR
\n\t WHERE 1 = 1
\n\t   and AIA.INVOICE_ID = AIP.INVOICE_ID
\n\t   AND HR.ORGANIZATION_ID = AIA.ORG_ID
\n\t   AND TO_CHAR(AIP.CREATION_DATE, 'YYYY-MM-DD') BETWEEN '2015-03-07' AND
\n\t       '2015-03-17'
\n\t GROUP BY HR.NAME \/*, AIA.INVOICE_NUM*\/
\n\t ORDER BY HR.NAME;\n<\/p>\n

\n\t\u8bf4\u660e\uff1a\u53d1\u7968\u7684\u4ed8\u6b3e\u4fe1\u606f\u53ef\u4ee5\u4ece\u673a\u6784\u3001\u53d1\u7968\u7f16\u53f7\u7b49\u7ef4\u5ea6\u53bb\u83b7\u53d6\u4ed8\u6b3e\u7684\u91d1\u989d\u3002\u4f46\u662f\u9700\u8981\u6ce8\u610f\u7684\u662f\uff0c\u7531\u4e8e\u4ed8\u6b3e\u4fe1\u606f\u662f\u9488\u5bf9\u4f9b\u5e94\u5546\u4ed8\u6b3e\uff0c\u800c\u4f9b\u5e94\u5546\u53ea\u5206\u914d\u7ed9\u67d0\u4e2a\u6216\u67d0\u51e0\u4e2a\u673a\u6784\u6765\u4f7f\u7528\uff0c\u5e76\u672a\u660e\u7ec6\u5206\u914d\u5230\u90e8\u95e8\u6bb5\u6765\u4f7f\u7528\uff0c\u56e0\u6b64\u65e0\u6cd5\u51c6\u786e\u7684\u4ece\u6210\u672c\u4e2d\u5fc3\u7684\u7ef4\u5ea6\u6765\u5c55\u793a\u4ed8\u6b3e\u4fe1\u606f\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"