1.取出表A中第31到第40记录a.select top 10 from a where id not in(selecttop 30from a)b.select top 10 from a where id>(select max(id) from (select top 30 from a))C.select * from(select *,ROW_NUMBER() over(order by id desc)as newId from goods_products) twhere t.newid>30 and t.newid<40 Read More