select elt(interval(d.device_main_category,0, 100, 200, 300,400,500,600,1000,20000), '小于100', '100到200', '200到300', '300到400','400到500','500到600','600到1000','1000到20000')
as physical_device_report_entity,
COUNT(d.device_main_category) as cnt
from physical_device_report_entity d
group by physical_device_report_entity
MySQL统计字段内区间的数量
最新推荐文章于 2022-10-27 16:05:34 发布