sql 按照季度进行分组

Da_Lian_

于 2021-08-03 14:58:22 发布

阅读量2.1k

点赞数

CC 4.0 BY-SA版权

分类专栏： 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