--查询学生信息,按照年龄升序排列;
SELECT * from stu ORDER BY age ;
--查询学生信息,按照数学成绩降序排列;
SELECT * from stu ORDER BY math desc;
--查询学生信息,按照数学成绩降序排列,如果数学成绩一样,再按照英语成绩升序排列;
SELECT * from stu ORDER BY math desc, english asc;
--查询学生信息,按照年龄升序排列;
SELECT * from stu ORDER BY age ;
--查询学生信息,按照数学成绩降序排列;
SELECT * from stu ORDER BY math desc;
--查询学生信息,按照数学成绩降序排列,如果数学成绩一样,再按照英语成绩升序排列;
SELECT * from stu ORDER BY math desc, english asc;