简单SQL语句实现分页效果

2013-12-12 14:30:23 99⁺

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

xe2制作Manifest并添加(UAC... asp访问java的webservice