时间排序和iD排序问题请教？

来源：百度知道 编辑：UC知道 时间：2024/06/23 08:15:05
<%set rs=server.createobject("adodb.recordset")
rs.open "select adddate,newsname,anclass,nclass,newscontent,newsid,jingpin from news where shenhe=1 and nclass="&nclassid,conn,1,1
%>

怎么让它按照时间排序，要插入什么！谢谢

后面加上 order by adddate 升序
order by adddate 降序

<%set rs=server.createobject("adodb.recordset")
rs.open "select adddate,newsname,anclass,nclass,newscontent,newsid,jingpin from news where shenhe=1 and nclass="&nclassid & " order by adddate, nclass",conn,1,1
%>

select 语句最后加
order by adddate 顺序
order by adddate desc 倒序

后面加上
order by adddate (desc)

order by adddate //如果adddate是你的时间字段