实现“查询学生及其选课情况(基于左外连接)”的SELECT语句为()。A.SELECT S.*, C.* FROM Student S JOIN SC ON S.Sno=SC.SnoB.SELECT S.*, C.* FROM Student S LEFT JOIN SC ON S.Sno=SC.SnoC.SELECT S.*, C.* FROM Student S, SC WHERE S.Sno=SC.SnoD.SELECT S.*, C.* FROM Student S OUTER JOIN SC ON S.Sno=SC.Sno
实现“查询学生及其选课情况(基于左外连接)”的SELECT语句为()。A.SELECT S.*, C.* FROM Student S JOIN SC ON S.Sno=SC.SnoB.SELECT S.*, C.* FROM Student S LEFT JOIN SC ON S.Sno=SC.SnoC.SELECT S.*, C.* FROM Student S, SC WHERE S.Sno=SC.SnoD.SELECT S.*, C.* FROM Student S OUTER JOIN SC ON S.Sno=SC.Sno
检索选修课程“C2”的学生中成绩最高的学生的学号。正确的SELECT语句是()。 A: SELECT SNO FROM SC WHERE CNO='C2' AND GRADE >= ( SELECT GRADE FORM SC WHERE CNO='C2' ); B: SELECT SNO FROM SC WHERE CNO='C2' AND GRADE IN ( SELECT GRADE FORM SC WHERE CNO='C2' ); C: SELECT SNO FROM SC WHERE CNO='C2' AND GRADE NOT IN ( SELECT GRADE FORM SC WHERE CNO='C2' ); D: SELECT SNO FROM SC WHERE CNO='C2' AND GRADE >= ALL ( SELECT GRADE FORM SC WHERE CNO='C2' );
检索选修课程“C2”的学生中成绩最高的学生的学号。正确的SELECT语句是()。 A: SELECT SNO FROM SC WHERE CNO='C2' AND GRADE >= ( SELECT GRADE FORM SC WHERE CNO='C2' ); B: SELECT SNO FROM SC WHERE CNO='C2' AND GRADE IN ( SELECT GRADE FORM SC WHERE CNO='C2' ); C: SELECT SNO FROM SC WHERE CNO='C2' AND GRADE NOT IN ( SELECT GRADE FORM SC WHERE CNO='C2' ); D: SELECT SNO FROM SC WHERE CNO='C2' AND GRADE >= ALL ( SELECT GRADE FORM SC WHERE CNO='C2' );
检索选修课程"C2”的学生中成绩最高的学生的学号,正确的SELECT语句是______。 A: SELECT S# FORM SC WHERE C#="C2"AND GRADE>=(SELECT GRADE FORM SC WHERE C#="C2") B: SELECT S# FORM SC WHERE C#="C2"AND GRADE IN(SELECT GRADE FORM SC) WHERE C#="C2" C: SELECT S# FORM SC WHERE C#="C2"AND GRADE NOT IN(SELECT GRADE FORM SC WHERE C#="C2") D: SELECT S# FORM SC WHERE C#="C2"AND GRADE>=ALL(SELECT GRADE FORM SC WHERE C#="C2")
检索选修课程"C2”的学生中成绩最高的学生的学号,正确的SELECT语句是______。 A: SELECT S# FORM SC WHERE C#="C2"AND GRADE>=(SELECT GRADE FORM SC WHERE C#="C2") B: SELECT S# FORM SC WHERE C#="C2"AND GRADE IN(SELECT GRADE FORM SC) WHERE C#="C2" C: SELECT S# FORM SC WHERE C#="C2"AND GRADE NOT IN(SELECT GRADE FORM SC WHERE C#="C2") D: SELECT S# FORM SC WHERE C#="C2"AND GRADE>=ALL(SELECT GRADE FORM SC WHERE C#="C2")
以下哪条语句可以实现查询选了课的学生人数( )。 A: select count(*) from sc B: select count(sno) from sc C: select count(distinct sno) from sc D: select count(cno) from sc
以下哪条语句可以实现查询选了课的学生人数( )。 A: select count(*) from sc B: select count(sno) from sc C: select count(distinct sno) from sc D: select count(cno) from sc
检索选修了课程”C1”的学生中成绩最高的学生的学号,正确的SELECT语句为( ) A: SELECT Sno FROM SC WHERE Cno=’C1’ AND GRADE >=ALL (SELECT Grade FROM SC WHERE Cno=’C1’); B: SELECT Sno FROM SC WHERE Cno=’C1’ AND GRADE IN (SELECT Grade FROM SC WHERE Cno=’C1’); C: SELECT Sno FROM SC WHERE Cno=’C1’ AND GRADE > ANY (SELECT Grade FROM SC WHERE Cno=’C1’); D: SELECT Sno FROM SC WHERE Cno=’C1’ AND GRADE >= (SELECT Grade FROM SC WHERE Cno=’C1’);
检索选修了课程”C1”的学生中成绩最高的学生的学号,正确的SELECT语句为( ) A: SELECT Sno FROM SC WHERE Cno=’C1’ AND GRADE >=ALL (SELECT Grade FROM SC WHERE Cno=’C1’); B: SELECT Sno FROM SC WHERE Cno=’C1’ AND GRADE IN (SELECT Grade FROM SC WHERE Cno=’C1’); C: SELECT Sno FROM SC WHERE Cno=’C1’ AND GRADE > ANY (SELECT Grade FROM SC WHERE Cno=’C1’); D: SELECT Sno FROM SC WHERE Cno=’C1’ AND GRADE >= (SELECT Grade FROM SC WHERE Cno=’C1’);
下列SQL语句中,_____________可以在“学生-课程”数据库正确实现“找出每个学生超过他选修课程平均成绩的课程号”。 A: SELECT Sno,CnoFROM SC xWHERE Grade >=(SELECT AVG(Grade) FROM SC y WHERE y.Sno=x.Sno) B: SELECT Sno,CnoFROM SC xWHERE (SELECT AVG(Grade) FROM SC y WHERE y.Sno=x.Sno)<=Grade C: SELECT Sno,CnoFROM SC WHERE Grade >=(SELECT AVG(Grade) FROM SC ) D: SELECT x.Sno,x.CnoFROM SC x, SC yWHERE y.Sno=x.Sno AND x.Grade >=(SELECT AVG(Grade) FROM y)
下列SQL语句中,_____________可以在“学生-课程”数据库正确实现“找出每个学生超过他选修课程平均成绩的课程号”。 A: SELECT Sno,CnoFROM SC xWHERE Grade >=(SELECT AVG(Grade) FROM SC y WHERE y.Sno=x.Sno) B: SELECT Sno,CnoFROM SC xWHERE (SELECT AVG(Grade) FROM SC y WHERE y.Sno=x.Sno)<=Grade C: SELECT Sno,CnoFROM SC WHERE Grade >=(SELECT AVG(Grade) FROM SC ) D: SELECT x.Sno,x.CnoFROM SC x, SC yWHERE y.Sno=x.Sno AND x.Grade >=(SELECT AVG(Grade) FROM y)
要从SC表中查找缺成绩(SCORE)的学生学号(NO),相应的SQL语句是( )。 A: SELECT NO FROM SC WHERE SCORE = 0 B: SELECT NO FROM SC WHERE SCORE IS 'NULL' C: SELECT NO FROM SC WHERE SCORE = NULL D: SELECT NO FROM SC WHERE SCORE IS NULL
要从SC表中查找缺成绩(SCORE)的学生学号(NO),相应的SQL语句是( )。 A: SELECT NO FROM SC WHERE SCORE = 0 B: SELECT NO FROM SC WHERE SCORE IS 'NULL' C: SELECT NO FROM SC WHERE SCORE = NULL D: SELECT NO FROM SC WHERE SCORE IS NULL
检索选修课程‘C2’的学生中成绩最高的学生的学号。正确的select语句为( )。 A: select S B: from sc where C C: =‘C2’and grade>= (select grade from sc where C D: =‘C2’) E: select S F: from sc where C G: =‘C2’and grade in (select grade from sc where C H: =‘C2’) I: select S J: from sc where C K: =‘C2’and grade not in (select grade from sc where C L: =‘C2’) M: select S N: from sc where C O: =‘C2’and grade>=all (select grade from sc where C P: =‘C2’)
检索选修课程‘C2’的学生中成绩最高的学生的学号。正确的select语句为( )。 A: select S B: from sc where C C: =‘C2’and grade>= (select grade from sc where C D: =‘C2’) E: select S F: from sc where C G: =‘C2’and grade in (select grade from sc where C H: =‘C2’) I: select S J: from sc where C K: =‘C2’and grade not in (select grade from sc where C L: =‘C2’) M: select S N: from sc where C O: =‘C2’and grade>=all (select grade from sc where C P: =‘C2’)
检索选修“C2”课程的学生中成绩最高的学生的学号。正确的SELECT语句是( )。 A: SELECT s B: FROM sc WHERE c C: =’C2’ AND grade>=(SELECT grade FROM sc WHERE c D: =’C2’); E: SELECT s F: FROM sc WHERE c G: =’C2’ AND grade IN(SELECT grade FROM sc WHERE c H: =’C2’); I: SELECT s J: FROM sc WHERE c K: =’C2’ AND grade NOT IN(SELECT grade FORM sc WHERE c L: =’C2’); M: SELECT s N: FROM sc WHERE c O: =’C2’ AND grade>=(SELECT max(grade) FROM sc WHERE c P: =’C2’);
检索选修“C2”课程的学生中成绩最高的学生的学号。正确的SELECT语句是( )。 A: SELECT s B: FROM sc WHERE c C: =’C2’ AND grade>=(SELECT grade FROM sc WHERE c D: =’C2’); E: SELECT s F: FROM sc WHERE c G: =’C2’ AND grade IN(SELECT grade FROM sc WHERE c H: =’C2’); I: SELECT s J: FROM sc WHERE c K: =’C2’ AND grade NOT IN(SELECT grade FORM sc WHERE c L: =’C2’); M: SELECT s N: FROM sc WHERE c O: =’C2’ AND grade>=(SELECT max(grade) FROM sc WHERE c P: =’C2’);
“把查询sc表和更新sc表的grade列的权限受予用户user1”的正确SQL语句是()。 A: GRANT SELECT, UPDATE(gradON TABLE sc TO user1 B: GRANT SELECT sc, UPDATE sc, grade TO user1 C: GRANT SELECT, UPDATE ON TABLE s grade TO user1 D: GRANT SELECT ON TABLE sc, UPDATE ON TABLE sc(grad TO user1
“把查询sc表和更新sc表的grade列的权限受予用户user1”的正确SQL语句是()。 A: GRANT SELECT, UPDATE(gradON TABLE sc TO user1 B: GRANT SELECT sc, UPDATE sc, grade TO user1 C: GRANT SELECT, UPDATE ON TABLE s grade TO user1 D: GRANT SELECT ON TABLE sc, UPDATE ON TABLE sc(grad TO user1