排序查询
语法格式
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;