G
Godfear
Unregistered / Unconfirmed
GUEST, unregistred user!
RT：如何用SQL查询第100条到200条的记录？
清
清新空气
Unregistered / Unconfirmed
GUEST, unregistred user!
select top 200 * from table where index_field not in<br>(select top 100 * from table)
B
boy2002cn
Unregistered / Unconfirmed
GUEST, unregistred user!
MSSQL select top 100 * from (select top 200 * from rs_da_grda) as A order by pcode<br>ORACLE<br>select * from (select rownum id,a.* from rs_da_grda a order by pcode) where id between 100 and 200
G
Godfear
Unregistered / Unconfirmed
GUEST, unregistred user!
多人接受答案了。
虫
虫虫2000
Unregistered / Unconfirmed
GUEST, unregistred user!
如果你是Sql Server 2000:<br>Select <br> top 100 * <br>From <br> (<br> Select <br> top 200 * <br> From 表名 <br> order by 字段名 <br>  
as tableName<br><br>order by 字段名 desc<br><br>如果你是Sql Server 2005:<br>Select * From <br> (Select <br> Row_Number() Over(order by 字段名 desc) as rowNum ,字段1,字段2<br> From<br> 表名 as 别名)<br>Where rowNum Between 100 and 200<br>Order by 字段名 desc
as tableName<br><br>order by 字段名 desc<br><br>如果你是Sql Server 2005:<br>Select * From <br> (Select <br> Row_Number() Over(order by 字段名 desc) as rowNum ,字段1,字段2<br> From<br> 表名 as 别名)<br>Where rowNum Between 100 and 200<br>Order by 字段名 desc