A．SELECT COUNT(DISTINCT学生号)FROM选课
B．SELECT COUNT(学生号)FROM选课
C．SELECT COUNT(*)FROM选课
D．SELECT COUNT(DISTINCT*)FROM选课
[单选题]利用SQL语句统计选修了“日语”课程的学生人数。请将下列的语句补充完整。SELECT______FROM 选课表 WHERE课程名="日语"
[单选题]已知基本表SC(S#，C#，GRADE)，则“统计选修了课程的学生人次数”的SQL语句为( )。A．SELECT COUNT(DISTINCTS#)/FROM SCB．SELECT COUNT(S#)/FROM SCC．SELECTCOUNT(*)/FROM SCD．SELECT COUNT (DISTINCT*)/FROM SC
[单选题]己知基本表SC(S#，C#，GRADE)，则“统计选修了课程的学生人次数”的SQL语句为A．SELECTCOUNT(DISTINCTS#)FROMSCB．SELECTCOUNT(S#)FROMSCC．SELECTCOUNT(*)FROMSCD．SELECTCOUNT(DISTINCT)FROMSC
[单选题]已知学生选课信息表：sc(sno，cno，grade)。查询“至少选修了一门课程，但没有学习成绩的学生学号和课程号”的SQL语句是A．SELECT sno，cno FROM sc WHERE grade=NULLB．SELECT sno，cno FROM sc WHERE grade IS‘’C．SELECT sno，cno FROM sc WHERE grade IS NULLD．SELECT sno，cno FROM sc WHERE grade=‘’
[单选题]要从学生成绩表(Stu_grade)中按课程号(Cno)统计出每门课程的选修人数，(27)可以实现这一功能。Stu_ gradeA．select Cno，count(stu_no)from Stu_grade group by CnoB．select Cno，count (stu_ no)from Stu_ gradeC．select Cno from Stu_gradeD．select Cno from Stu_grade group by Cno
[单选题]在学生选课表(SC)中，查询选修了3号课程(课程号CH)的学生的学号(XH)及其成绩(GD)。查询结果按分数的降序排列。实现该功能的正确SQL语句A．SELECT XH，GD FROM SC： WHERE CH='3F' ORDER BY GD DESCB．SELECT XH，GD FROM SC； WHERE CH='3'ORDER BY GD ASCC．SELECT XH，GD FROM SC； WHERECH='3'GROUP BY GD DESCD．SELECTXH，GDFR
[单选题]在学生选课表(SC) 中，查询选修了3号课程(课程号CH)的学生的学号(XH)及其成绩(GD) 。查询结果按分数的降序排列。实现该功能的正确SQL语句( )。A．SELECR XH，GD FROM SC WHERE CH='3' ORDER BY GD DESC：B．SELECT XH，GD FROM SC WHERE CH='3' ORDER BY GD ASC；C．SELECT XH，GD FROM SC WHERE CH='3'GROUP BY GD DESC；D．SELECT
[单选题]“查询选修了3门以上课程的学生的学生号”，正确的SQL语句是A．sELEcT S#FROM SC GROUP BY S#WHERE COUNT(*)>3B．SELECT s#FROM SC GROUP．BY S#HAVING COtJNT(*)>3C．sELECT S#FROM SC ORDER BY S#HAVING COUNT(*)>3D．sELECT S#FROM SC ORDER BY S#WHERE COUNT(*)>3
[单选题]在学生表中查找没有选课的学生，下列语句正确的是( )。A．SELECT*FROM 学生 WHERE EXISTS； (SELECT*FROM 选课 WHERE学生号=学生.学生号)B．SELECT*FROM 学生 WHERE NOT EXISTS； (SELECT*FROM 选课 WHERE 学生号=学生.学生号)C．SELECT*FROM 学生 WHERE EXISTS； (SELECT*FROM 选课 WHERE 学生号=学生号)D． SELECT*FROM 学生 WHERE NOT EXI
[单选题]在学生选课表(SC)中，查询选修了3号课程的学生的学号(XH)及其成绩(GD))，查询结果按分数的降序排列。实现该功能的正确SQL语句是______。A．SELECT XH,GD FROM SC WHERE CH="3"ORDER BY GD DESCB．SELECT XH,GD FROM SC WHERE CH="3"ORDER BY GD ASCC．SELECT XH,GD FROM SC WHERE CH="3"GROUP BY GD DESCD．SELECT XH,GD FR