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