A.SELECT 课号,AVG(成绩),MAX(成绩),MIN(成绩),COUNT(学号)FROM 选课GROUP BY 课号;
B.SELECT 课号,AVG(成绩),MAX(成绩),MIN(成绩),COUNT(学号) FROM 选课HAVING 课号;
C.SELECT 课号,AVG(成绩),MAX(成绩),MIN(成绩),COUNT(学号) FROM 选课WHERE 课号;
D.SELECT 课号,AVG(成绩),MAX(成绩),MIN(成绩),COUNT(学号) FROM 选课ORDER BY 课号;
第1题
A、SELECT 姓名 FROM 学生 WHERE 学号 IN (SELECT 学号 FROM 选课 GROUP BY 学号 HAVING COUNT(*) >= 3);
B、SELECT 姓名 FROM 学生 WHERE 学号 IN (SELECT 学号 FROM 选课 GROUP BY 学号 COUNT(*) >= 3);
C、SELECT 姓名 FROM 学生 WHERE 学号 (SELECT 学号 FROM 选课 GROUP BY 学号 HAVING COUNT(*) >= 3);
D、SELECT 姓名 FROM 学生 WHERE 学号 IN (SELECT 学号 FROM 选课 ORDER BY 学号 HAVING COUNT(*) >= 3);
第2题
A、SELECT 课号,AVG(成绩),MAX(成绩),MIN(成绩),COUNT(学号) FROM 选课 GROUP BY 课号;
B、SELECT 课号,AVG(成绩),MAX(成绩),MIN(成绩),COUNT(学号) FROM 选课 ORDER BY 课号;
C、SELECT 课号,AVG(成绩),MAX(成绩),MIN(成绩),COUNT(学号) FROM 选课 WHERE 课号;
D、SELECT 课号,AVG(成绩),MAX(成绩),MIN(成绩),COUNT(学号) FROM 选课 HAVING 课号;
第3题
A、SELECT 课号,AVG(成绩),MAX(成绩),MIN(成绩),COUNT(学号) FROM 选课 GROUP BY 课号;
B、SELECT 课号,AVG(成绩),MAX(成绩),MIN(成绩),COUNT(学号) FROM 选课 ORDER BY 课号;
C、SELECT 课号,AVG(成绩),MAX(成绩),MIN(成绩),COUNT(学号) FROM 选课 WHERE 课号;
D、SELECT 课号,AVG(成绩),MAX(成绩),MIN(成绩),COUNT(学号) FROM 选课 HAVING 课号;
第4题
A、SELECT 姓名 FROM 学生 WHERE 学号 IN (SELECT 学号 FROM 选课 GROUP BY 学号 HAVING COUNT(*) >= 3);
B、SELECT 姓名 FROM 学生 WHERE 学号 IN (SELECT 学号 FROM 选课 GROUP BY 学号 COUNT(*) >= 3);
C、SELECT 姓名 FROM 学生 WHERE 学号 (SELECT 学号 FROM 选课 GROUP BY 学号 HAVING COUNT(*) >= 3);
D、SELECT 姓名 FROM 学生 WHERE 学号 IN (SELECT 学号 FROM 选课 ORDER BY 学号 HAVING COUNT(*) >= 3);
第5题
A、UPDATE 选课 SET 成绩=成绩+10 WHERE 课号=‘1002’;
B、UPDATE 选课 SET 成绩=成绩+10 WHERE 课号=1002;
C、SET 选课 UPDATE 成绩=成绩+10 WHERE 课号=‘1002’;
D、UPDATE 选课 SET 成绩+10 WHERE 课号=‘1002’;
第6题
A、DELETE FROM 课程 WHERE 课号=‘2003’;
B、DELETE FROM 课程 WHERE 课号=2003;
C、DELETE FROM 课程 WHERE ‘2003’;
D、DELETE FROM 课程.课号=‘2003’;
第7题
A、DELETE FROM 课程 WHERE 课号=‘2003’;
B、DELETE FROM 课程 WHERE 课号=2003;
C、DELETE FROM 课程 WHERE ‘2003’;
D、DELETE FROM 课程.课号=‘2003’;
第8题
A、DELETE FROM 课程 WHERE 课号=‘2003’;
B、DELETE FROM 课程 WHERE 课号=2003;
C、DELETE FROM 课程 WHERE ‘2003’;
D、DELETE FROM 课程.课号=‘2003’;
第9题
A、SELECT DISTINCT 学号 FROM 选课 WHERE 课号=‘1001’ AND 学号 IN (SELECT DISTINCT 学号 FROM 选课 WHERE 课号=‘2002’ );
B、SELECT DISTINCT 学号 FROM 选课 WHERE 课号=‘1001’ AND 课号=‘2002’;
C、SELECT DISTINCT 学号 FROM 选课 WHERE 课号=‘1001’ AND 学号 IN ( FROM 选课 WHERE 课号=‘2002’ );
D、SELECT DISTINCT 学号 FROM 选课 WHERE 课号=‘1001’ AND 学号 (SELECT DISTINCT 学号 FROM 选课 WHERE 课号=‘2002’ )
第10题
如下几个表所示学生、课程、必修课和选课关系。已知SQL语句“SELECT DISTINCT 课号 FROM 必修课;”,其正确的检索结果是_____。
A、
B、
C、
D、其它选项都不正确
为了保护您的账号安全,请在“上学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!