查询问题

hellenism 发布于 2009-11-01 18:16， 548 次点击

查询选修编号为“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

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

2 回复

gdy03492009-11-01 19:30

你用个子查询不就行了吗

师妃暄2009-11-09 12:03

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