查询符合条件的第21条到第30条记录： select top 10 * from table_name where id not in(select top 20 id from table_name order by id asc) order by id asc