查询选修了课程号为“C2”的学生中成绩最高的学生的学号,正确的SELECT语句是()。 A: SELECTS B: FROMSC WHEREC C: ='C2'ANDGRADE>=ALL D: (SELECTGRADE FROMSC WHEREC E: ='C2') F: SELECTS G: FROMSC WHEREC H: ='C2'ANDGRADEIN I: (SELECTMAX(GRADE) FROMSC WHEREC J: ='C2') K: SELECTS L: FROMSC WHEREC M: ='C2'ANDGRADE= N: (SELECTMAX(GRADE) FROMSC WHEREC O: ='C2') P: SELECTS Q: FROMSC WHEREC R: ='C2'ANDGRADE>=ANY S: (SELECTGRADE FROMSC WHEREC T: ='C2')
查询选修了课程号为“C2”的学生中成绩最高的学生的学号,正确的SELECT语句是()。 A: SELECTS B: FROMSC WHEREC C: ='C2'ANDGRADE>=ALL D: (SELECTGRADE FROMSC WHEREC E: ='C2') F: SELECTS G: FROMSC WHEREC H: ='C2'ANDGRADEIN I: (SELECTMAX(GRADE) FROMSC WHEREC J: ='C2') K: SELECTS L: FROMSC WHEREC M: ='C2'ANDGRADE= N: (SELECTMAX(GRADE) FROMSC WHEREC O: ='C2') P: SELECTS Q: FROMSC WHEREC R: ='C2'ANDGRADE>=ANY S: (SELECTGRADE FROMSC WHEREC T: ='C2')
关系模式S(A,B,C,D)代数中的σ3<’2’(S)等价于如下的( )语句。 A: SELECT *FROM S WHEREC B: SELECTB,CFROM S WHERE C C: SELECT B,C FROMS HAVING C D: SELECT* FROM SWHERE’3’
关系模式S(A,B,C,D)代数中的σ3<’2’(S)等价于如下的( )语句。 A: SELECT *FROM S WHEREC B: SELECTB,CFROM S WHERE C C: SELECT B,C FROMS HAVING C D: SELECT* FROM SWHERE’3’
1