sql排序
xxx:引用的表
1.从高到低排序
order by
用法:
select * from xxx
order by 字段
2.从低到高排序
order by desc
用法:
select * from xxx
order by 字段 desc
3.【进阶】排序后显示第n行数据
思路:
- 先进行排序(默认从高到底)
- 显示1-n行数据
- 再排序(从低到高即从n到1)
select * from (select * from xxx
order by 字段 limit n) order by 字段 desc limit 1