sql 按照季度进行分组

最新推荐文章于 2023-11-23 11:45:15 发布

Da_Lian_

最新推荐文章于 2023-11-23 11:45:15 发布

阅读量2.1k

点赞数

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

本文链接：https://blog.youkuaiyun.com/Programmer_FuQiang/article/details/119350223

版权

sql 同时被 2 个专栏收录

6 篇文章

订阅专栏

mysql

3 篇文章

订阅专栏

select
case when month(date) =1 or month(date) =2
           or month(date)=3 then '一季度'
when month(date) =4 or month(date) =5
           or month(date)=6 then '2季度'
when month(date) =7 or month(date) =8
           or month(date)=9 then '3季度'
when month(date) =10 or month(date) =11
           or month(date)=12 then '4季度'
else '' end ,sum(数量)
from "表名"
group by
case when month(date) =1 or month(date) =2
           or month(date)=3 then '一季度'
when month(date) =4 or month(date) =5
           or month(date)=6 then '2季度'
when month(date) =7 or month(date) =8
           or month(date)=9 then '3季度'
when month(date) =10 or month(date) =11
           or month(date)=12 then '4季度'
else '' end