区段统计 mysql 语句 case when then end as

最新推荐文章于 2022-11-10 11:32:02 发布

weixin_30349597

最新推荐文章于 2022-11-10 11:32:02 发布

阅读量120

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/huangtaozi/p/3755687.html

版权

EXPLAIN SELECT COUNT(*),
CASE
WHEN device_width > 729 THEN '>729'
WHEN device_width BETWEEN '720' AND '729' THEN '720-729'
WHEN device_width BETWEEN '710' AND '720' THEN '710-720'
ELSE '<710'
END AS t
FROM weimeng_click_record
GROUP BY
CASE
WHEN device_width > 729 THEN '>729'
WHEN device_width BETWEEN '720' AND '729' THEN '720-729'
WHEN device_width BETWEEN '710' AND '720' THEN '710-720'
ELSE '<710'
END

转载于:https://www.cnblogs.com/huangtaozi/p/3755687.html