直接上干货GROUP BY SUBSTRING(CONVERT(varchar(100), w.operatedate, 120),1,7)
举例:
select COUNT(id),SUBSTRING(CONVERT(varchar(100), w.operatedate, 120),1,7)
from IVMS_Workflow_Record w
GROUP BY SUBSTRING(CONVERT(varchar(100), w.operatedate, 120),1,7)
直接上干货GROUP BY SUBSTRING(CONVERT(varchar(100), w.operatedate, 120),1,7)
举例:
select COUNT(id),SUBSTRING(CONVERT(varchar(100), w.operatedate, 120),1,7)
from IVMS_Workflow_Record w
GROUP BY SUBSTRING(CONVERT(varchar(100), w.operatedate, 120),1,7)