MSSQL简单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