sql语句划分时间时间分组

最新推荐文章于 2022-04-20 10:47:16 发布

$scope.靠谱青年

最新推荐文章于 2022-04-20 10:47:16 发布

阅读量1.4k

点赞数

分类专栏： sql 文章标签： sql

本文链接：https://blog.youkuaiyun.com/qq_36236621/article/details/105296736

版权

sql 专栏收录该内容

13 篇文章

订阅专栏

-- 时间上按月划分
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