1、查询学生信息,按照年龄升序排列
select * from stu order by age asc;
2、查询学生信息,按照数学成绩降序排列
select * from stu orde by math desc;
3、查询学生信息,按照数学成绩降序排列,如果数学成绩一样,再按照英语成绩升序排列
select * from stu order by math desc,english asc;
1、查询学生信息,按照年龄升序排列
select * from stu order by age asc;
2、查询学生信息,按照数学成绩降序排列
select * from stu orde by math desc;
3、查询学生信息,按照数学成绩降序排列,如果数学成绩一样,再按照英语成绩升序排列
select * from stu order by math desc,english asc;