下列选项中,用于将 student 表按照 gender 字段进行分组查询,并且查询 score 字段值之和小于300的分组的 SQL 语句是
A: SELECT gender , SUM ( score ) FROM student GROUP BY gender HAVING SUM ( score )<;300;
B: SELECT gender , SUM ( score ) FROM student GROUP BY gender WHERE SUM ( score )300;
C: SELECT gender , SUM ( score ) FROM student WHERE SUM ( score )<;300 GROUP BY gender ;
D: 以上语句都不对
A: SELECT gender , SUM ( score ) FROM student GROUP BY gender HAVING SUM ( score )<;300;
B: SELECT gender , SUM ( score ) FROM student GROUP BY gender WHERE SUM ( score )300;
C: SELECT gender , SUM ( score ) FROM student WHERE SUM ( score )<;300 GROUP BY gender ;
D: 以上语句都不对
举一反三
- 查询student表中id字段值小于5,并且gender字段值为“女”的学生姓名的SQL语句是() A: SELECT name FROM student WHERE id<;5 OR gender='女'; B: SELECT name FROM student WHERE id<;5 AND gender='女'; C: SELECT name FROM student WHERE id<;5 ,gender='女'; D: SELECT name FROM student WHERE id<;5 AND WHERE gender='女';
- 查询student表中的gender字段（gender代表性别），使其查询记录中不能出现重复值的SQL语句是（1.0分） A: SELECT gender FROM student; B: SELECT DISTINCT * FROM student; C: SELECT DISTINCT gender FROM student; D: SELECT * FROM student;
- 【单选题】查询student表中id字段值小于5,并且gender字段值为“女”的学生姓名的SQL语句是 A. SELECT name FROM student WHERE id<5 OR gender‘女’; B. SELECT name FROM student WHERE id<5 AND gender=‘女’; C. SELECT name FROM student WHERE id<5 ,gender=‘女’; D. SELECT name FROM student WHERE id<5 AND WHERE gender=‘女’;
- 下列选项中,能够按照 score 由高到低显示 student 表中记录的 SQL 语句是 A: SELECT* FROM student ORDER BY score ; B: SELECT* FROM student ORDER BY score ASC ; C: SELECT * FROM student ORDER BY score DESC ; D: SELECT* FROM student GROUP BY score DESC ;
- 设有学生选课表score(sno,cname,grade),其中sno表示学生学号,cname表示课程名,grade表示成绩。以下能够统计每个学生选课数的语句是()。 A: SELECT<br/>COUNT(*) FROM score GROUP BY sno ; B: SELECT<br/>COUNT(*) FROM score GROUP BY cname ; C: SELECT<br/>SUM(*) FROM score GROUP BY cname ; D: SELECT<br/>SUM(*) FROM score GROUP BY sno ;