sql查询从第几条到第几条数据
--从第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)
