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.结束
转载于:https://www.cnblogs.com/envenler/archive/2011/09/07/2170039.html