1.查询“001”课程比“002”课程成绩高的所有学生的学号 select distinct a.sidfrom SC a,SC bwhere a.sid=b.sid and a.cid='001' and b.cid='002' and a.score > b.score;Student表:sc表:Teacher:Course表: mysql 2024-01-27 116 点赞 1 评论 175 浏览