1、根据公司和日期分组 获得发票数据量
SELECT
PAY_TAXES_ORGNAME,
--BILLING_NO,
LEFT(INVOICE_OPEN_DATE,7) AS MM,
COUNT(1) AS NUM
--,INVOICE_STATE,
--sum(case when INVOICE_STATE=1 then 1 else 0 end) AS 蓝票,
--sum(case when INVOICE_STATE=2 then 1 else 0 end) as 红票,
--sum(case when INVOICE_STATE=4 then 1 else 0 end) as 作废成功
--INVOICE_NUMBER,
--INVOICE_CODE
FROM
TBL_TXN_INVOICE
WHERE
INVOICE_OPEN_STATE = 3
and INVOICE_STATE in(1,2,4)
AND INVOICE_CODE IS NOT NULL
GROUP BY LEFT(INVOICE_OPEN_DATE,7),PAY_TAXES_ORGNAME --,INVOICE_STATE
2、根据公司和日期分组 获得不同发票状态下的发票数据量
SELECT
PAY_TAXES_ORGNAME 公司,
--BILLING_NO,
LEFT(INVOICE_OPEN_DATE,7) 年月,
--INVOICE_NUMBER,