列出选修编号为“3－105”课程且成绩高于选修了编号为“3－245”的同学的CNO、SNO和DEGREE。

参考答案:

SELECT CNOSNODEGREE FROM SCORE WHERE CNO="3-105"AND DEGREE＞ALL(SELECT DEGREE FROMSCORE WHERE CNO="3-245")SELECT CNO，SNO，DEGREE FROM SCORE WHERE CNO="3-105"AND DEGREE＞ALL(SELECT DEGREE FROMSCORE WHERE CNO="3-245")