请在 下方输入 要搜索的题目:

从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 ;

发布时间:2025-06-11 08:34:39
推荐参考答案 ( 由 快搜搜题库 官方老师解答 )
联系客服
答案:select name, age, score from student order by age desc , score;; select name, age, score from student order by 2 desc , 3 asc;
专业技术学习
专业技术学习
搜搜题库系统