WOLO07的博客

原创 2021-01-29

SQL试题： 查询所有课程成绩小于60分的同学的学号、姓名 简化方法： select sid,sname from student where sid in(select sid from sc group by sid having max(score)<60) #木鱼脑袋解法： select sid,sname from student where sid in (select distinct v.sid from (select sid,count(t.cid) as cou...