查出第十 到 第二十条记录

select top 10  * from table where id not in( select top 10 id from table order by id desc) order by id desc



select top 10 * from(select Top 20 * from table_A order by id desc)


更新数据时维护一个连续编号字段

select  * from table where 连续编号字段>9 and 连续编号字段<21