Mysql_DQL操作表_排序查询(重点)

--查询学生信息,按照年龄升序排列;
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;