【简答题】设教学数据库Education有三个关系: 学生关系S(SNO,SNAME,AGE,,SDEPT); 学习关系SC(SNO,CNO,GRADE); 课程关系C(CNO,CNAME,CDEPT,TNAME) Sno学号,sname姓名,age年龄,性别,sdept专业,cno课程号,cname课程吗,grade分数,cdept开课院系,tname教师名。查询问题: 查询选修了3门以上课程...
【简答题】老子在《道德经》中所讲的“天之道”有( )( )。(选二)。
【单选题】基于“学生-选课-课程”数据库中的3个关系:S(S#,SNAME,,DEPARTMENT),主码是S#C(C#,CNAME,TEACHER),主码是C#SC(S#,C#,GRADE),主码是(S#,C#)若要“查询选修了3门以上课程的学生的学号”,则正确的SQL语句是( )。
A.
SELECT S# FROM SC GROUP BY S# WHERE COUNT(*)> 3
B.
SELECT S# FROM SC GROUP BY S# HAVING COUNT(*)> 3
C.
SELECT S# FROM SC ORDER BY S# WHERE COUNT(*)> 3
D.
SELECT S# FROM SC ORDER BY S# HAVING COUNT(*)> 3
【单选题】若要“查询选修了3门以上课程的学生的学号”,则正确的sQL语句是( )
A.
SELECT S# FrOmsC GROUPBY S# WHERE COUNT(*)> 3
B.
SELECTS# FROm sC GROUP BY S# HAVING COUNT(*)>3
C.
SELECT S# FROMSC OrDER BY S# WHERE COUNT(*)>3
D.
SELECT S# FROMSC ORDERBY S# HAVING COUNT(*)>3
【简答题】老子在《道德经》中所讲的“天之道”有( )( )。(选二)。
【多选题】老子在《道德经》中所讲的 “天之道”有( )( )。
【单选题】“学生-选课-课程”数据库中的3个关系: S#,SNAME,,DEPARTMENT),主码是S#; C#,CNAME,TEACHER),主码是C#; (S#,C#,GRADE),主码是(S#,C#)。 “查询选修了3门以上课程的学生的学号”,则正确的SQL语句是( )。
A.
SELECT S# FROM SC GROUP BY S# WHERE COUNT(*)> 3
B.
SELECT S# FROM SC GROUP BY S# HAVING COUNT(*)> 3
C.
SELECT S# FROM SC ORDER BY S# WHERE COUNT(*)> 3
D.
SELECT S# FROM SC ORDER BY S# HAVING COUNT(*)> 3
【多选题】老子在《道德经》中所讲的“天之道”有( )。
【单选题】“学生-选课-课程”数据库中的3个关系: (S#,SNAME,,DEPARTMENT),主码是S#; C(C#,CNAME,TEACHER),主码是C#; SC(S#,C#,GRADE),主码是(S#,C#)。 若要“查询选修了3门以上课程的学生的学号”,则正确的SQL语句是( )。
A.
SELECT S# FROM SC GROUP BY S# WHERE COUNT(*)> 3
B.
SELECT S# FROM SC GROUP BY S# HAVING COUNT(*)> 3
C.
SELECT S# FROM SC ORDER BY S# WHERE COUNT(*)> 3
D.
SELECT S# FROM SC ORDER BY S# HAVING COUNT(*)> 3