MySQL数据库-数据的排序操作（order by）命令演示

最新推荐文章于 2023-05-26 00:22:57 发布

HXH.py

最新推荐文章于 2023-05-26 00:22:57 发布

阅读量4.6k

点赞数 4

分类专栏： MySQL 文章标签： MySQL 数据库排序 order by

本文链接：https://blog.csdn.net/weixin_44850984/article/details/89918726

版权

20 篇文章 1 订阅

订阅专栏

asc从小到大排列，即升序
desc从大到小排序，即降序

查询年龄在18到34岁之间的男性，按照年龄从小到到排序
select * from students where (age between 18 and 34) and gender=1;
select * from students where (age between 18 and 34) and gender=1 order by age;
select * from students where (age between 18 and 34) and gender=1 order by age asc;
查询年龄在18到34岁之间的女性，身高从高到矮排序
select * from students where (age between 18 and 34) and gender=2 order by height desc;

查询年龄在18到34岁之间的女性，身高从高到矮排序, 如果身高相同的情况下按照年龄从小到大排序
select * from students where (age between 18 and 34) and gender=2 order by height desc, age asc;
查询年龄在18到34岁之间的女性，身高从高到矮排序, 如果身高相同的情况下按照年龄从小到大排序,如果年龄也相同那么按照id动大到小排序
select * from students where (age between 18 and 34) and gender=2 order by height desc, age asc, id desc;
按照年龄从小到大、身高从高到矮的排序
select * from students order by age asc, height desc;

关注