sql 按照季度进行分组

最新推荐文章于 2024-07-06 07:36:03 发布

Programmer_FuQiang

最新推荐文章于 2024-07-06 07:36:03 发布

阅读量2k

点赞数

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

本文链接：https://blog.csdn.net/Programmer_FuQiang/article/details/119350223

版权

sql 同时被 2 个专栏收录

6 篇文章 0 订阅

订阅专栏

mysql

3 篇文章 0 订阅

订阅专栏

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