UC知道select语句问题，查询区间语句问题！【高手进】
来源：百度知道 编辑：UC知道 时间：2024/06/19 07:12:14
<%
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查询语句该怎么改，多谢！
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查询语句该怎么改，多谢！
WITH article2 AS
(SELECT *,
ROW_NUMBER() OVER (order by r_date desc)as RowNumber
FROM article )
SELECT *
FROM article2
WHERE RowNumber between 16 and 30;
SQLSERVER2005测试通过
mysql中语句最后加上 LIMIT 16,30