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)