作者：手机用户2502923513 | 来源：互联网 | 2014-06-09 00:50
SQL语句按年龄段分组统计人数Java代码www.2cto.comcreatetable#t(Unamevarchar(10),ageint)insert#tselect'啊啊',19unionallselect'信息',23unionallselec..
SQL语句按年龄段分组统计人数
create table #t(Uname varchar(10),age int)
insert #t
select &＃39;啊啊&＃39;,19 union all
select &＃39;信息&＃39;,23 union all
select &＃39;宝宝&＃39;,31 union all
select &＃39;喔喔&＃39;,21 union all
select &＃39;米米&＃39;,6
select nnd as &＃39;年龄段&＃39;,count(*) as &＃39;人数&＃39; from(
select
case
when age>=1 and age<=10 then &＃39;1-10&＃39;
when age>=11 and age<=20 then &＃39;11-20&＃39;
when age>=21 and age<=30 then &＃39;21-30&＃39;
when age>=31 and age<=40 then &＃39;31-40&＃39;
end
as nnd,uname from #t
)a group by nnd
京公网安备 11010802041100号 | 京ICP备19059560号-4 | PHP1.CN 第一PHP社区 版权所有 