--1
select 学号,姓名,入学成绩
from xs
where 入学成绩>500 and 性别='男'
--2
select 性别,MAX(入学成绩) as 最高分,MIN(入学成绩) as 最低分
from xs
group by 性别
select [学号],[成绩]
from xs
where [成绩] > 500
and [性别] = '男'
select max([成绩]) as [成绩最高分],min([成绩]) as [成绩最低分], [性别]
from xs group by [性别]
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024