Question

asp中怎么让Access数据库表中某一项从大到小排列出来

asp中怎么让Access数据库表中某一项从大到小排列出来？？？

Answer 1

Select * from Table Order By 要排序的字段名 Desc或Asc
Desc是降序，也就是从大到小
Asc是升级，从小到大

Answer 2

就这样啊
set rs =server.createobject("adodb.recoredset")
sql="select * from table by user_id desc"
rs.open sql conn,1,1

Answer 3

select * from 表名 by 字段名 desc