如何查询从第100条到第200条纪录?

[nicolahul]

查询前100条记录是select top 100 * from,那么查询第100条至200条记录的sql语句怎么写啊？？

[csdn_study]

先查询出所有的记录然后用一条循环语句取出第100条至200条的记录就可以了.

[xzou]

如果有唯一的id做排序的话可以用
select top 100 * from (select top 200 * from yourtable order by id) a order by a.id desc

[jadesun]

Select Top 100 * From (Select Top 200 * From tablename Order by ColumID DESC) as Tmp
Order by ColumnID ASC

[karma]

assume you are doing an "order by",

select top 200 * from sometable order by A ASC

then do a reverse order
select top 100 * from (select top 200 * from sometable order by A ASC) t order by A DESC

reverse it again
select * from (select top 100 * from (select top 200 * from sometable order by a asc) t order by A DESC) t2 order by A ASC

[希偌]

Select Top 100 * From (Select Top 200 * From tablename Order by ColumID DESC) as Tmp Order by ColumnID ASC
or
Select Top 100 * From (Select Top 200 * From tablename Order by ColumID ASC) as Tmp Order by ColumnID desc

[playmud]

楼上说的都是sql server吧。？
mysql比较简单，有一个可以取任意连续的纪录。

[julyclyde]

MySQL
select limit

[IflyingCD]

set rs=maindb.execute(select * from table)
for i=1 to 100
res.movenext
next
接下来就可以取101条记录了

[Triumph]

Select * From Table_Name Where ID>100 And ID<200

[ksy]

rs.move 101

[coollzh]

rs.pageSize=100
rs.AbosutePage=2

[wang0628]

关系数据库中好像没有顺序的概念吧？

[lucong]

sql server只有７.0以上版本才支持ＴＯＰ。

如果不用ＴＯＰ，还有什么办法？用存储过程怎么写？

[liangxuan1979]

在Sql里，
最好先把所有记录抓出来，前面的家伙已经讲了；
然后移动recordset，等移动到第100条时，开始写数据出来。
如果你用Asp写过分页，应该知道怎么回事！

[csdnling]

select * from tablename where rownum>100 and rownum<201 (oracle)

[sunrainnet]

把所有记录抓出来 再排除应该会慢点吧,如果我要的是第10000至20000条岂不是要MOVENEXT 10000 次后才可以开始取！！