mysql 排序

排序：

order by

asc 从小到达，默认值

desc 从大到小

 

查询18 到 35岁 男性，按年龄从小到大排序：

select * from students where age between 18 and 35 and gender="男" order by age;

select * from students where age between 18 and 35 and gender=1 order by age asc;

 

查询18 到35岁男性，按年龄从大到小排序：

select * from students where (age between 18 and 35) and gender=1 order by age desc;

 

如果上面的语句查询出多个相同的年龄，那这几个年龄默认按照id排序，order by排序支持多个字段，

也就是说可以再次对这几个相同的年龄再次进行排序,如果第一个排序没有重复值，那么第二个排序字段就没有作用：

select * from students where age between 18 and 35 and gender=1 order by age desc,id desc;