sql="select top 页大小 *
from table1
where id<=
(select min (id) from
(select top ((页码-1)*页大小) id from table1 order by id desc) as
T
)
oeder by id desc";
from table1
where id<=
(select min (id) from
(select top ((页码-1)*页大小) id from table1 order by id desc) as
T
)
oeder by id desc";