假设是以id(唯一)排序。select top 30 * from
(
select * from t where id<>(select top 1 id from t order by id)
) as a
order by id
(
select * from t where id<>(select top 1 id from t order by id)
) as a
order by id
调试欢乐多
(select top 31 * from t order by id) as a order by id desc