SQL语句按年龄段分组统计人数_MySQL
程序员文章站
2022-06-06 08:07:26
...
bitsCN.com
SQL语句按年龄段分组统计人数
Java代码
create table #t(Uname varchar(10),age int)
insert #t
select '啊啊',19 union all
select '信息',23 union all
select '宝宝',31 union all
select '喔喔',21 union all
select '米米',6
select nnd as '年龄段',count(*) as '人数' from(
select
case
when age>=1 and age
when age>=11 and age
when age>=21 and age
when age>=31 and age
end
as nnd,uname from #t
)a group by nnd
上一篇: PHP 生成RSS 类