mysql case when(二)

最新推荐文章于 2024-10-05 14:16:38 发布

u014400257

最新推荐文章于 2024-10-05 14:16:38 发布

阅读量124

点赞数

分类专栏： sql 文章标签：数据库

本文链接：https://blog.csdn.net/u014400257/article/details/84768420

版权

sql 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

select
sum(case when a.integral <=5000 and a.integral >=1 then 1 else 0 end) as '1-5000积分',
sum(case when a.integral <=10000 and a.integral >=5001 then 1 else 0 end) as '5001-10000积分',
sum(case when a.integral <=15000 and a.integral >=10001 then 1 else 0 end) as '10001-15000积分',
sum(case when a.integral <=20000 and a.integral >=15001 then 1 else 0 end) as '15001-20000积分',
sum(case when a.integral >20000 then 1 else 0 end) as '20000积分以上'
from da_account a where date(a.created_at)>DATE_SUB(CURDATE(), INTERVAL 3 YEAR) and date(a.created_at)<=DATE_SUB(CURDATE(), INTERVAL 2 YEAR)