下列选项中,能够按照 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 ;
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 ;
举一反三
- 从student表中查询学生姓名、年龄和成绩，结果按照年龄降序排序，年龄相同的按照成绩升序排序，下面SQL语句正确的是： A: select name, age, score from student order by age desc , score; B: select name, age, score from student order by age , score asc; C: select name, age, score from student order by 2 desc , 3 asc; D: select name, age, score from student order by 1 desc , 2；
- 查询学生成绩，将成绩首先按英语，然后按数学从高到低排序，正确的语句是（ ）。 A: select * from score order by english asc,maths asc B: select * from score order by english desc,maths desc C: select * from score order by maths,english D: select * from score order by english,maths
- 下列选项中,用于将 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: 以上语句都不对
- 在SCORE表中,按成绩升序排列存入NEW表中,应使用的SQL语句是( ). A: SELECT * FROM SCORE ORDER BY 成绩 B: SELECT * FROM SCORE ORDER BY 成绩 INTO TABLE NEW C: SELECT * FROM SCORE ORDER BY 成绩 TO NEW D: SELECT * FROM SCORE ORDER BY 成绩 INTO CURSOR NEW
- 在SCORE表中，按成绩升序排列存入NEW表中，应使用的SQL语句是 A: SELECT * FROM SCORE ORDER BY 成绩 INTO NEW B: SELECT * FROM SCORE ORDER BY 成绩 INTO CURSOR NEW C: SELECT * FROM SCORE ORDER BY 成绩 INTO TABLE NEW D: SELECT * FROM SCORE ORDER BY 成绩 TO NEW