查询选修编号为“3-105”且成绩高于选修编号为“3-245”课程的同学的Cno、Sno和Degree

SELECT ,SC1.Sno,SC1.Degree
FROM Score SC1,Score SC2
WHERE '3-105' AND
      '3-245' AND
      SC1.Degree>SC2.Degree

我用了自身连接 但是结果不对 请指点 谢谢

你用个子查询不就行了吗

这样,方法笨了点,保证不会错
SELECT ,SC1.Sno,SC1.Degree
FROM Score SC1
WHERE '3-105'
       AND SC1.Degree>(select SC2.Degree from Score SC2 where '3-245')