一:(利用NOT IN 和 SELECT TOP 分页)
select top 10 *
from TestTable
where (ID not in
(select top 20 id
from TestTable
order by id))
order by ID
select top 页大小 *
where (ID not in
(select top 页大小*页数 id
from TestTable
order by id))
order by ID
一:(利用NOT IN 和 SELECT TOP 分页)
select top 10 *
from TestTable
where (ID not in
(select top 20 id
from TestTable
order by id))
order by ID
select top 页大小 *
where (ID not in
(select top 页大小*页数 id
from TestTable
order by id))
order by ID