语法格式

select * from 表名 order by 列1 asc|desc [, 列2 asc|desc,...]

• 将数据按照列1排序，如果某些行列1的值相同时i，按照列2排序，以此类推
• asc, 从小到大，升序
• desc, 从大到小，降序
• 默认asc

-- 查询年龄在18到34岁之间的男性，身高从矮到高排序
SELECT * FROM students WHERE (age BETWEEN 18 AND 60) AND gender =1;
SELECT * FROM students WHERE (age BETWEEN 18 AND 60) AND gender =1 ORDER BY height ASC;

-- 查询年龄在18到34岁之间的女性，身高从高到矮排序
SELECT * FROM students WHERE (age BETWEEN 18 AND 60) AND gender =2 ORDER BY height DESC;

-- 查询年龄在18到34岁之间的女性，身高从高到矮排序, 如果身高相同，按照年龄从大到小排序
SELECT * FROM students WHERE (age BETWEEN 18 AND 60) AND gender =2 ORDER BY height DESC, age DESC;