mysql 查询分段_mySql 分段查询

准备：

创建一个成绩表

Create table grade (id integer, score integer);

插入数据(只有id每次加一，score是1到100的随机数，java生成)：

public class GradeInsertSentence {

public static void main(String[] args) {

for (int i = 0; i < 100; i++) {

int j = (int) (Math.random()*100) + 1;

System.out.println("insert into grade(id,score) value(‘"+i+"‘,‘"+j+"‘);");

}

}

}

查询grade表的所有数据

Select * from grade;

需求：

查询指定分段的人数(x>=80; 80>x>=60; 60>x>40; 40>x>=20, x<20 )

Sql：

实现1：

select *

from

(select count(*) as A from grade g where g.score >=80) a,

(select count(*) as B from grade g where g.score >=60 and g.score <80) b,

(se