select top pageSize tableName.* from tableName inner join (select top pageSize ID from (select top pageSize * pageIndex ID from tableName order by ID desc) order by ID asc)as p on p.ID=tableName.ID order by tableName.ID desc
1.select top pagesize * from table where id not in (select id from table where id<pagesize*(pageindex-1) order by id desc) order by id desc
2.select top pagesize * from table where id>(select max(id) from (select top pagesize*(pageindex-1)) id from table order by id desc as t ) order by id desc
Access性能比较差,不能用not in,而要用max方法:
select top 50 * from 测试 where 主键字段>(select max(主键字段) from (select top 1000 主键字段 from 测试 order by 主键字段) order by 主键字段
[/Quote]