sqlserver2000数据库分页查询[根据网上搜索到得sql修改]
程序员文章站
2023-11-18 18:53:34
sqlserver2000分页查询[根据网上搜索到得sql修改]
select top 页大小 *
from testtable
where...
sqlserver2000分页查询[根据网上搜索到得sql修改]
select top 页大小 * from testtable where (id > (select case when count(0) < 页大小 then 0 else max(id) end from (select top 页大小*(页数-1) id from 表 order by id) as t)) order by id