摘要:
-- 查询没有学全所有课的同学的学号、姓名;SELECT sid,sname FROM student stu, (SELECT COUNT(sid) as num,student_id FROM score GROUP BY student_id)t1 , -- 查出每个人的学习课程数量(SELE 阅读全文
摘要:
问题以及表结构来自:https://www.cnblogs.com/wupeiqi/articles/5729934.html -- 查询学生本人“生物”课程比“物理”课程成绩高的所有学生的学号;SELECT * FROM ((SELECT * FROM score WHERE corse_id i 阅读全文