#1. 查询“01”课程比“02”课程成绩高的所有学生的学号;
SELECT
a.sid
FROM
DATA.sc AS a
LEFT JOIN DATA.sc AS b ON a.SId = b.SId
AND a.CId = '01'
AND b.CId = '02'
WHERE
a.score > b.score
注:这里inner left right的结果一样
#变式:1.查询" 01 "课程比" 02 "课程成绩高的学生的信息及课程分数
SELECT
*
FROM
DATA.sc AS a
LEFT JOIN DATA.student AS d ON a.SId = d.sid
INNER JOIN DATA.sc AS b ON a.SId = b.SId
AND a.CId = '01'
AND b.CId = '02'
WHERE
a.score > b.score