统计个分数段人数

统计个分数段的人数sql

1.

select   

    sum(case   when   分数   >=40   and   分数  <60   then   1   else   0   end)   as   '40-59',   

    sum(case   when   分数   >=60   and   分数  <85   then   1   else   0   end)   as   '60-84',   

    sum(case   when   分数  >=85   then   1   else   0   end)   as   '85-'                       

from   分数表

2.

select 分数段, 人数=count(*)from

(

  select 分数, 分数段=case

    when 分数= 0 then'0' 

    when 分数 between 0  and 9  then'1～9'

    when 分数 between 10 and 19 then'10～19'

    when 分数 between 20 and 29 then'20～29'

    when 分数 between 30 and 39 then'30～39'

    when 分数 between 40 and 49 then'40～49'

    when 分数 between 50 and 59 then'50～59'

    when 分数 between 60 and 69 then'60～69'

    when 分数 between 70 and 79 then'70～79'

    when 分数 between 80 and 89 then'80～89'

    when 分数 between 90 and 99 then'90～99'

    when 分数= 100 then'100'

    end

  from tb 

) t

group by 分数段

转载于:https://www.cnblogs.com/shuaisam/archive/2012/03/27/2419917.html