当前位置:首页 > 数据库 > SQL

一种范畴统计和聚合的SQL

优良自学吧提供一种范畴统计和聚合的SQL,一种范围统计和聚合的SQL 例子:   select sum(case when age<=6 then 1 else 0 END) as \'0-6\', sum(case when age>=7 an

一种范围统计和聚合的SQL

例子:


select sum(case when age<=6 then 1 else 0 END) as '0-6', sum(case when age>=7  and age<=18 then 1 else 0 END) as '7-18', sum(case when age>=19  and age<=25 then 1 else 0 END) as '19-25', sum(case when age>=26  and age<=30 then 1 else 0 END) as '26-30', sum(case when age>=31  and age<=35 then 1 else 0 END) as '31-35', sum(case when age>=36  and age<=40 then 1 else 0 END) as '36-40', sum(case when age>=41  and age<=45 then 1 else 0 END) as '41-45', sum(case when age>=46  and age<=50 then 1 else 0 END) as '46-50', sum(case when age>=51  and age<=55 then 1 else 0 END) as '51-55', sum(case when age>=56  and age<=60 then 1 else 0 END) as '56-60', sum(case when age>=61  and age<=65 then 1 else 0 END) as '61-65', sum(case when age>=66  and age<=70 then 1 else 0 END) as '66-70', sum(case when age>=71  and age<=75 then 1 else 0 END) as '71-75', sum(case when age>=76  and age<=80 then 1 else 0 END) as '76-80', sum(case when age>=81  then 1 else 0 END) as '≧81' from ( select age from his_sign hs ) age  


(本文来自互联网,不代表搜站(http://www.ylzx8.cn/)的观点和立场)
本站所有内容来自互联网,若本站收录的信息无意侵犯了贵司版权,请给我们来信(ylzx8cn@163.com),我们会及时处理和回复,谢谢