--从第31条到第40条(M -N条)
select top 10 * from TB_GoodsLicenseAssociation where idx not in (select top 30 idx from TB_GoodsLicenseAssociation)
select top N-M+1 * from tablename where id not in (select top M-1 id from tablename)
--从第31条到第40条(M -N条)
select top 10 * from TB_GoodsLicenseAssociation where idx not in (select top 30 idx from TB_GoodsLicenseAssociation)
select top N-M+1 * from tablename where id not in (select top M-1 id from tablename)
转载于:https://www.cnblogs.com/SnailWalk/archive/2013/03/14/2959436.html