题目
A.SELECT Sno, Sname FROM Student, SC WHERE Student.Sno = SC.Sno AND SC.Cno= ‘2’ AND SC.Grade > 90
B.SELECT Student.Sno, Sname FROM Student, SC WHERE Student.Sno = SC.Sno AND SC.Grade > 90
C.SELECT Sno, Sname FROM Student, SC WHERE SC.Cno= ‘2’ AND SC.Grade > 90
D.SELECT Student.Sno, Sname FROM Student, SC WHERE Student.Sno = SC.Sno AND SC.Cno= ‘2’ AND SC.Grade > 90
第1题
第2题
第3题
第5题
第6题
A.SC.成绩>=’B’
B.SC.成绩<=’B’
C.SC.成绩≤’B’
D.SC.成绩!<’B’
第7题
A.SELECT 学号, COUNT(*) FROM 成绩 WHERE 分数>90 GROUP BY 学号 HAVING COUNT(*)>3;
B.SELECT 学号, COUNT(学号) FROM 成绩 WHERE 分数>90 AND COUNT(学号)>3;
C.SELECT 学号, COUNT(*) FROM 成绩 GROUP BY 学号 HAVING COUNT(*)>3 AND 分数>90;
D.SELECT 学号, COUNT(*) FROM 成绩 WHERE 分数>90 AND COUNT(*)>3 GROUP BY 学号;
第8题
第9题
第10题
第11题
为了保护您的账号安全,请在“赏学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!