22,210
社区成员
发帖
与我相关
我的任务
分享
select top 5 * from
(select top 10 * from tA order by id asc) page_table1
where id not in
(select top 5 id from tA order by id asc)
select top 5 * from
(select top 10 id,* from tA order by id asc) page_table1 where id not in
(select id from (select top 5 * from tA order by id asc) page_table2)
order by id