select * from user oreder by time desc limit 0,20select * from user oreder by time desc limit 20,40select * from user oreder by time desc limit 40,60select * from user oreder by time desc limit 60,80select * from user oreder by time desc limit 80,100这样不就可以了?
select * from user order by time desc limit 20 , 20 -- limit 后面那两个数,头一个是 从多少行开始,第二个是出多少行数据。