Mysql:如何使用limit

2019独角兽企业重金招聘Python工程师标准>>>

1.当我们需要获取在某一排序下前n个记录

select * from my_pen order by a_code desc limit 0,n

2.当我们需要获取在某一排序下第n个记录

select * from my_pen order by a_code desc limit n-1,1

3.当我们需要获取在某一排序下[n,m]的记录

select * from my_pen order by a_code desc limit n-1,m-n+1

转载于:https://my.oschina.net/hengbao666/blog/1837705