列出选修编号为“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")