Question

sql 降序改成升序

一下代码默认为降序，如何改成升序
<%
'set rs3=server.CreateObject("ADODB.RecordSet")
'for i=1 to RecordCount
'sortname=sortName(i)
set rs=Server.CreateObject("ADODB.Recordset")
sql="select * from class"
rs.open sql,conn,1,1

'Dim sortName(20)
while not rs.EOF
%>

--------------------------
sql="select * from class order by id desc"

这样改过没有用，请高手指教
Microsoft JET Database Engine 错误 '80040e14'

ORDER BY 子句语法错误。

/index.asp，行 597

rs.open sql,conn,1,1

Answer 1

order by 字段
这样默认的就是按该字段升序排列，也可以显式声明，即
order by 字段 ASC

order by 字段 DESC
这样就是按该字段降序排列了。

Answer 2

哥哥，，升序
是order by id asc

select * from class order by id asc

Answer 3

应该是select * from class order by id asc
升序应该是asc；不是desc

Answer 4

sql="select * from class order by id"

或

sql="select * from class order by id asc"

Answer 5

select top 100 percent * from class order by id desc