sql统计近四个季度的总值_sql 四个季度-优快云博客

本文链接：https://blog.youkuaiyun.com/awen6666/article/details/103615096

本文介绍了一种使用SQL来统计最近四个季度财务数据总值的方法，通过复杂的CASE WHEN语句结合日期函数，准确地筛选出每个季度的数据并进行求和，最后计算出本年度的总金额。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

sql统计近四个季度的总值

quarter(date)
获取date当前季度，now()获取当前日期
if(expr1,expr2,expr3)
如果expr1为true则expr2，否则expr3
DATE_SUB(date,INTERVAL expr unit)
获取date日期减去expr个unit，unit可以是year，day，month，quarter等值
case when 判断条件 than 语句1 else 语句2 end
当判断条件为true时执行语句1，为false时执行语句2

近四个季度依次分别为q4,q3,q2,q1;本年总值为amount1.
select a.emp_id,
    sum(case when a.year=IF(QUARTER(NOW())<=3,YEAR(NOW())-1,YEAR(NOW())) and quarter=QUARTER(DATE_SUB(NOW(),INTERVAL 3 QUARTER)) then a.amount else null end) as q1 ,
    sum(case when a.year=IF(QUARTER(NOW())<=2,YEAR(NOW())-1,YEAR(NOW())) and quarter=QUARTER(DATE_SUB(NOW(),INTERVAL 2 QUARTER)) then a.amount else null end) as q2 ,
    sum(case when a.year=IF(QUARTER(NOW())<=1,YEAR(NOW())-1,YEAR(NOW())) and quarter=QUARTER(DATE_SUB(NOW(),INTERVAL 1 QUARTER)) then a.amount else null end) as q3 ,
    sum(case when a.year=YEAR(NOW()) and quarter=QUARTER(NOW()) then a.amount else null end) as q4,
    sum(case when a.year=YEAR(NOW()) then a.amount else null end) as amount1,