1. 查询各科成绩均在80分以上的学生姓名

select name from (
select name, min(score) from student
group by name
having min(score) > 80
) stu
select name from (
select name, min(score) from student
group by name
having min(score) > 80
) stu
本文标题:SQL
本文链接:https://www.haomeiwen.com/subject/xphbfctx.html
网友评论