MySQL区间统计SQL

最新推荐文章于 2024-09-07 09:57:05 发布

weixin_30532369

最新推荐文章于 2024-09-07 09:57:05 发布

阅读量528

点赞数

CC 4.0 BY-SA版权

文章标签：数据库

原文链接：http://www.cnblogs.com/gslblog/p/8706965.html

SELECT
elt(
INTERVAL (
datediff(END_DATE, CURDATE()),
1,
201,
401,
601
),
'0-200',
'200-400',
'400-600',
'>600'
) AS `name`,
COUNT(INDIV_PIN) AS `value`
FROM
t_test
WHERE
`STATUS` = 3
GROUP BY
elt(
INTERVAL (
datediff(END_DATE, CURDATE()),
1,
201,
401,
601
),
'0-200',
'200-400',
'400-600',
'>600'
),INDIV_PIN