sql语句:select count(*),substr(t.openOrderTime,1,10) from tbl_Workorder_Work_Order t where t.openOrderTime like '2018-05%' group by substr(t.openOrderTime,1,10)
效果:
sql语句:select count(*),substr(t.openOrderTime,1,10) from tbl_Workorder_Work_Order t where t.openOrderTime like '2018-05%' group by substr(t.openOrderTime,1,10)
效果: