对查询结果排序
SELECT 字段 1,字段 2...FROM 表名 ORDER BY 属性名 [ASC|DESC]
eg:根据年龄递增排序
select * from t_student order by age;
eg:根据年龄递增排序(用asc, 默认就是asc升序排列)
select * from t_student order by age asc;
eg:根据年龄递减排序(desc降序排列)
select * from t_student order by age desc;