select语句问题，查询区间语句问题！【高手进】【高悬赏】

来源：百度知道 编辑：UC知道 时间：2024/06/18 14:23:58
<%
set rs1=server.CreateObject("adodb.recordset")
sqltext="Select top 15 * from article where item=39 order by r_date desc"
rs1.open sqltext,conn,1,1
if rs1.bof and rs1.eof then
else
do while not rs1.eof
%>
这段语句是查询数据库article表的前15条，请大侠们告诉我如何查询从第16条到30条的select查询语句该怎么改，多谢！
这写语句是查询article表中item字段=39的前15条结果，我想要的是从15条到30条的结果。谢谢你们
目前你们写的都不好使啊，5555哇5555哇......
我的网站是asp+access数据库的，上面的语句是显示数据库中一部分内容的

select top 15 * from
(select top 30 * from article order by id) a
order by id desc

Select * from article where id between 16 and 30 and item=39 order by r_date desc

试下行不

select * from (select top 30 * from article where item=39 order by r_date desc) a where a.id not in (select top 15 * from article where item=39 order by r_date asc)

-------------------------------------------------
什么意思?? 不能用吗??按你的意思应该这样能实用的呢
-------------------------------------------------------------
sqltext="Select top 15 * from article where item=39 order by r_date desc"
这个换成
sqltext="select * from (select top 30 * from article where item=39 order by r_date desc) a where a.id not in (select top 15 * from article where item=39 order by r_date asc) "

不矢你是否用的oracle
可以这样写
select * from table where rownum >=15 and rownum<=30;