weixin_44679921的博客

SQL⾯试题讲 1.⽤⼀条SQL语句查询出每⻔课都⼤于80分的学⽣姓名 select name from mst_stu group by name having min(score)>80;

数据库 查询" 01 “课程⽐” 02 "课程成绩⾼的学⽣的信息及课程分数 select student.SId,Sname,Sage,Ssex,CId,score from student left join sc on student.SId=sc.SId where student.SId in(select sc1.SId from sc sc1 join sc sc2 on sc1.SId=sc2.SId where sc1.CId='01' and sc2.CId='02' and sc1.