--简单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
转载于:https://www.cnblogs.com/star5/archive/2011/01/26/1945104.html