MySQL排序和分组使用的命令
排序 order by
一、 order by 单字段
——默认从小到大排序,字段后面隐藏了asc条件,当条件为desc时,按从大到小排序。
示例1:查询年龄在18到34岁之间的男性,按照年龄从小到大排序:
select * from student where (age between 18 and 34) and (gender="男") order by age;
示例2:查询年龄在18到34岁之间的女性,按照身高从高到矮排序:
select * from student where (age betwwen 18 and 34) and (gender="女") order by height desc;
二、 order by 多字段
——字段从左到右权重递减。
示例1:查询年龄在18到34岁之间的女性,按照身高从高到矮排序,如果身高相同则按照年龄从小到大排序:
select * from student where (age betwwen 18 and 34) and (gender="女") order by height desc,age asc;
示例2:按年龄从大到小排序,相同情况下按身高从小到大排序:
select * from student order by age desc,hei