Question

SQL语句如何查询每个班级中最低的分数

SQL表结构如图

Answer 1

select * from 表 a where id in(select top 1 id from 表 where 班级=a.班级 order by 分数)

Answer 2

select class(班级),min(分数) from 表 group by class(班级)

Answer 3

select class,B.成绩 from 表B where B.成绩 in (select min(A.成绩)from 表A group by class )

Answer 4

select class,min(成绩)
from 表
group by class