请问： 要想从数据表第二行取数据该怎么做？

[ahuiok]

如果一个数据表有100行数据记录。

我想从第二行数据取以后的三十条。

请问该怎么做啊？

[gmlxf]

假设是以id（唯一）排序。

select top 30 * from
(
select * from t where id<>(select top 1 id from t order by id)
) as a
order by id

[gmlxf]

select top 30 * from t where id not in (select min(id) from t) order by id

[gmlxf]

select top 30 * from
(select top 31 * from t order by id) as a order by id desc