奥非域

简单SQL语句实现分页效果

--简单SQL语句实现分页效果,每页100行

--前三页

select top 300 * from tsendresult

order by fid

--第一页

select top 100 * from tsendresult

order by fid

--第二页

select top 100 * from tsendresult

where fid not in (select top 100 fid from tsendresult order by fid)

order by fid

--第三页

select top 100 * from tsendresult

where fid not in (select top 200 fid from tsendresult order by fid)

order by fid