请在 下方输入 要搜索的题目：
推荐参考答案 (
由 搜题小帮手 官方老师解答 )
答案：
以下文字与答案无关
提示：有些试题内容 显示不完整,文字错误 或者 答案显示错误等问题，这是由于我们在扫描录入过程中 机器识别错误导致,人工逐条矫正总有遗漏，所以恳请 广大网友理解。
相关试题
- 1.针对学生选课数据库S_T，以下哪条语句可以实现查询选了课的学生人数（ ）。选项： A:select count(cno) from sc; B:select count(sno) from sc; C:select count(*) from sc; D:select count(distinct sno) from sc
- 2.针对学生选课数据库S_T,以下哪条语句可以实现查询选了课的学生人数( )。A.select count(distinct sno) from scB.select count(*) from scC.select count(cno) from scD.select count(sno) from sc
- 3.关系代数练习-学生选课（题干）.docx根据附件内容，查询已经选了课的学生人数。 选项：select COUNT(sNo) from SC;#select COUNT(*) from SC;#select COUNT(DISTINCT sNo) from SC;#select COUNT(DISTINCT *) from SC;
- 4.以下SQL语句中，____________可以在“学生-课程”数据库正确实现“查询选修了课程的学生总人数”。 选项： A、SELECT COUNT(Sno) FROM SC B、SELECT COUNT(DISTINCT Sno) FROM SC C、SELECT COUNT(*) FROM SC D、SELECT SUM(Sno) FROM SC
- 5.17e0a6a212da224.gif关系代数练习-学生选课（题干）.docx根据附件内容，查询已经选了课的学生人数。 选项： A、select COUNT(sNo) from SC; B、 select COUNT(*) from SC; C、 select COUNT(DISTINCT sNo) from SC; D、 select COUNT(DISTINCT *) from SC;
- 6.针对学生选课表sc（sno, cno, grade），其中sno为学号，cno为课程号，grade为成绩。以下（ ）语句可查询选修了两门以上成绩在90分以上课程的学生学号。选项： A:select sno from sc where grade>90 group by sno having count(distinct sno)>2; B:select sno from sc where grade>90 group by sno having count(cno)>2; C:select sno from sc where grade>90 and count(*)>2 group by sno; D:select sno from sc where grade>90 group by sno having count(*)>2
- 7.查询被选修过的课程数量，可以使用的查询语句是：（） 选项：SELECT COUNT(DISTINCT Cno) FROM SC;#SELECT AVG(DISTINCT *) FROM SC;#SELECT COUNT(ALL Cno) FROM SC;#SELECT COUNT(*) FROM SC;
- 8.下列利用SC表的查询语句中，错误的是()选项： A:SELECT Sno, COUNT(*) FROM SC GROUP BY Sno; B:SELECT Sno FROM SC GROUP BY Sno HAVING COUNT(*) > 3; C:SELECT Sno FROM SC GROUP BY Sno WHERE COUNT(*) > 3; D:SELECT Sno FROM SC GROUP BY Sno
- 9.查询被选修过的课程数量，可以使用的查询语句是： 。 选项：A、SELECT COUNT(DISTINCT Cno) FROM SC; B、SELECT AVG(DISTINCT *) FROM SC; C、SELECT COUNT(ALL Cno) FROM SC; D、SELECT COUNT(*) FROM SC;
- 10.以下（ ）语句可查询选修了三门以上成绩在80分以上课程的学生学号。 A: select sno from scwhere grade>80group by snohaving count(cno)>3 B: select sno from scwhere grade>80group by snohaving count(*)>3 C: select sno from scwhere grade>80 and count(*)>3group by sno D: select sno from scwhere grade>80group by snohaving count(sno)>3
- 11.下列哪些语句是统计CS系的学生人数选项： A:SELECT COUNT(Sno) FROM Student GROUP BY Sdept B:SELECT COUNT(Sno) FROM Student WHERE Sdept ="CS" C:SELECT COUNT(*) FROM Student WHERE Sdept ="CS" D:SELECT MAX(Sno) FROM Student WHERE Sdept ="CS"
- 12.[单选题]查询班级学生的人数。 A SELECT COUNT(*) FROM s B SELECT SUM(*) FROM s C SELECT AVG(*) FROM s D SELECT COUNT(*) FROM sc
- 13.以下（ ）语句可查询选修了三门以上成绩在80分以上课程的学生学号。 选项： A、select sno from scwhere grade>80group by snohaving count(cno)>3 B、select sno from scwhere grade>80group by snohaving count(*)>3 C、select sno from scwhere grade>80 and count(*)>3group by sno D、select sno from scwhere grade>80group by snohaving count(sno)>3
- 14.已知学生选课信息表：sc(sno,cno,grade)。查询“至少选修了一门课程，但没有学习成绩的学生学号和课程号”的SQL语句是（ ）。 选项： A:SELECT sno,cno FROM sc WHERE grade=NULL; B:SELECT sno,cno FROM sc WHERE grade IS '' ; C:SELECT sno,cno FROM sc WHERE grade IS NULL ; D:SELECT sno,cno FROM sc WHERE grade=''
- 15.已知学生选课信息表：sc(sno,cno,grade)。查询“至少选修了一门课程，但没有学习成绩的学生学号和课程号”的SQL语句是( )。选项： A:SELECT sno,cno FROM sc WHERE grade=NULL B:SELECT sno,cno FROM sc WHERE grade IS C:SELECT sno,cno FROM sc WHERE grade IS NULL D:SELECT sno,cno FROM sc WHERE grade=
- 16.针对学生选课数据库S_T，以下（ ）操作实现了student表与sc之间的自然连接。选项： A:select student.* , cno, grade from student join sc on student.sno=sc.sno; B:select student.* , sc.* from student , sc where student.sno=sc.sno; C:select student.sno, sname, ssex, sage, sdept , cno, grade from student , sc where student.sno=sc.sno; D:select student.* , cno, grade from student , sc where student.sno=sc.sno
