支持access的sql语句分页,速度特快!!!

每页显示10条记录,当前显示第4页(4*10),默认按id降序排序

select * from (select top 120 * from [person] order by id) temtb  order by id  desc

 

 

每页显示10条记录,当前显示第4页(4*10),按id升序排序

 

select  * from (select top 40 * from (select top 120 * from [person] order by id) temtb  order by id  desc) temtb2 order by id

每页显示10条记录,当前显示第4页(4*10),按uname降序排序

select * from (select top 10 * from (select top 40 * from [person] order by id) temtb  order by id  desc) temtb2 order by uname desc

 

 

通过asp+access测试,使用一50m左右的access数据库，person表含5324条记录，每条记录含大量数据，速度如同select top 10 * from [person]快,可放心使用

从

select * from (select top 120 * from [person] order by id) temtb  order by id  desc

执行情况看，ado是先排序，后取记录。