40、查询不同课程成绩相同的学生的 学生编号、课程编号、学生成绩
①、该学生所有课程成绩相同
解法1:
SELECT SC1.sid,SC1.score AS 课程1成绩, SC2.score AS 课程2成绩,SC3.score AS 课程3成绩
FROM (SELECT * FROM SC WHERE cid='01') AS SC1
INNER JOIN (SELECT * FROM SC WHERE cid='02') AS SC2
ON SC1.sid=SC2.sid
INNER JOIN (SELECT * FROM SC WHERE cid='03') AS SC3
ON SC2.sid=SC3.sid
WHERE SC1.score=SC2.score
AND SC2.score=SC3.