1. 取出所有数据
select id from news
结果如下:
2.从第五条数据开始取
select id from news where id not in (select top 5 id from news )
结果如下:
3.结束
1. 取出所有数据 select id from news 结果如下:
2.从第五条数据开始取 select id from news where id not in (select top 5 id from news ) 结果如下:
3.结束 |