sql语句划分时间 时间分组

-- 时间上按月划分
select datename(year,operatedate)+datename(month,operatedate)as 年月 ,count (ID) as 统计 
from IVMS_Workflow_Record r group by datename(year,operatedate)+datename(month,operatedate)
	
-- 时间上按旬划分
select case (datepart(day,operatedate)-1)/10 when 0 then '上旬' when 1 then '中旬' else '下旬' end as 旬,count (ID) as 统计 
 from IVMS_Workflow_Record 
 group by  case (datepart(day,operatedate)-1)/10 when 0 then '上旬' when 1 then '中旬' else '下旬' end 

-- 时间上按年旬划分
select datename(year,operatedate)+datename(month,operatedate)+case (datepart(day,operatedate)-1)/10 when 0 then '上旬' when 1 then '中旬' else '下旬' end as 日期,count (ID) as 统计
 from IVMS_Workflow_Record 
 group by datename(year,operatedate)+datename(month,operatedate)+case (datepart(day,operatedate)-1)/10 when 0 then '上旬' when 1 then '中旬' else '下旬' end