select top 10 * from (select top 20 * from table AS a order by id asc) order by id DESC //先按照顺序取前20条记录,然后在选择的记录基础上倒序取前10条,正好是10-20条记录,273-300的用法同理.