按月份统计数据

SELECT convert(varchar(6),yw_date,112),count(*) from
alu_kingdee_sales_receipt_detail
where
remark = '销售出库单'
group by convert(varchar(6),yw_date,112) order by 1;

 

 

销售出库单
201901 23540
201902 9365
201903 31493
201904 28986
201905 31462
201906 26491
201907 29006
201908 28461
201909 29958
201910 29288
201911 32904
201912 37959
202001 7800
202002 982
202003 17306
202004 31882
202005 29866
202006 30202
202007 27028
202008 27118
202009 27407
202010 22718
202011 26508
202012 28039