Question

用select top 方法，如何选择第8-10条记录

有一段代码：<%
Set rs = Server.CreateObject("ADODB.Recordset")
rs.open "Select top 10 * from [Host_List] where sales=1 order by prodno asc",conn,1,1
if not (rs.eof or rs.bof) then
count=rs.recordcount
i=1
do while not rs.eof
if len(session("Grade"))=0 then
price = rs("price1")
else
price = rs("price"&Grade)
end if
if i mod 2<>0 then
%> 问题：上面的代码中的Select top 10 是选择前10条记录的，请问如何实现选择第8-10条记录呢，谢谢各位大虾了！！

Answer 1

select * from (select row_number() over(order by prodno asc) as rowid,* from [Host_List]) t where rowid between 8 and 10 第二种（效率低点）select top 2 * from [Host_List] where prodno not in (select top 10 prodno from [Host_List] order by prodno asc) order by prodno asc

Answer 2

1、假设表有id类字段，内容1至100或更多。
2、假设表名为zdxxb，id字段为zdid
3、select top 方法如下：
select * from (select top 3 * from (select top 10 * from zdxxb order by zdid asc) order by zdid desc) order by zdid asc

Answer 3

请问查询的是什么数据库，如果是mysql的话，很简单，最后加个条件limit 8,10就可以了，不同数据库有不同的分页显示办法的

Answer 4

Select top 3 From [Host_List] Where Prodno in(Select top 10 prodno from [Host_List] where sales=1 order by prodno desc)

Answer 5

用asc的话就是升序排列 那你 直接用 top 3 不就是 10条记录里的后三条吗