从student表中查询学生姓名、年龄和成绩，结果按照年龄降序排序，年龄相同的按照成绩升序排序，下面SQL语句正确的是：

任务中心

2023-07-11

多选题

833人参与 · 461人答对

来自：墨天轮 — 贡献 619 题

从student表中查询学生姓名、年龄和成绩，结果按照年龄降序排序，年龄相同的按照成绩升序排序，下面SQL语句正确的是：

select name,age,score from student order by age desc,score;

select name,age,score from student order by 2 desc,3 asc;

select name age,score from student order by 1 desc,2;

select name,age,score from student order by age,score asc;

A. select name,age,score from student order by age desc,score;

B. select name,age,score from student order by 2 desc,3 asc;

C. select name age,score from student order by 1 desc,2;

D. select name,age,score from student order by age,score asc;

来自：墨天轮 — 贡献 619 题

提交答案

答题后参与讨论

扫一扫，小程序答题更便捷

微信订阅，每日一题不错过

题目正确率排行

倒序正序