下面的SQL查询语句中的排序方法是（ ）。 SELECT * FROM tb_student order by id,age 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；
- 下面的SQL查询语句中的排序方法是（）。 SELECT * FROM tb_student order by id desc,age; A: 返回的记录按id降序排列 B: 返回的记录按age降序排列 C: 返回的记录先按id降序排列，再按age升序排列 D: 返回的记录先按id升序排列，再按age降序排列
- 已知学生表student(sid,sname,sex,age0，其各个属性分别表示学号、姓名、性别和年龄，若要从表中检索所有学生的信息，检索结果按年龄由大到小排序，下列SQL语句正确的是（ ） A: select * from student order by age B: select * from student group by age C: select * from student order by age desc D: select * from student group by age desc
- 查询主键id从高到低排序的前10条记录的语句是（） A: SELECT * FROM table ORDER BY id ASC limit 1,10 B: SELECT * FROM table ORDER id DESC limit 10 C: SELECT * FROM table ORDER BY id DESC limit 10 D: SELECT * FROM table ORDER id ASC limit 1,10
- 下列选项中,能够按照 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 ;