3.2w+
社区成员
- 主页
- 基础类
- 应用实例
- 新技术前沿
求助：如何进行分段统计
如何按学生成绩（stu.score）进行分段统计，比如按60分以下、60－80、80分以上几段。最好一条语句的。谢谢先了
...全文
请发表友善的回复…
发表回复
parade78 2003-01-21
ok，谢谢两位
yujohny 2003-01-21
select (case
when score<60 then COUNT(score) AS 不及格人数
when score<80 and score>=60 then COUNT(score) AS 及格人数
when score>80 then COUNT(score) AS 优秀人数
end) FROM 表1
when score<60 then COUNT(score) AS 不及格人数
when score<80 and score>=60 then COUNT(score) AS 及格人数
when score>80 then COUNT(score) AS 优秀人数
end) FROM 表1
CrazyFor 2003-01-21
select
sum(case when score<60 then 1 else 0 end) as 不及格数，
sum(case when ....................
sum(case when score<60 then 1 else 0 end) as 不及格数，
sum(case when ....................
CrazyFor 2003-01-21
select (case
when score<60 then '不及格'
when score<80 and score>60 then 'XX'
when score>80 then 'YYYYY'
end)
select
sum(case when score<60 then 1 else 0 end) as 不及格数，
sum(case when ....................
when score<60 then '不及格'
when score<80 and score>60 then 'XX'
when score>80 then 'YYYYY'
end)
select
sum(case when score<60 then 1 else 0 end) as 不及格数，
sum(case when ....................
parade78 2003-01-21
是统计总数
CrazyFor 2003-01-21
select (case
when score<60 then '不及格'
when score<80 and score>60 then 'XX'
when score>80 then 'YYYYY'
end)
是这个意思吗？
when score<60 then '不及格'
when score<80 and score>60 then 'XX'
when score>80 then 'YYYYY'
end)
是这个意思吗？