UC知道asp降序排列
来源：百度知道 编辑：UC知道 时间：2024/09/23 05:27:26
set rs=server.createobject("adodb.recordset")
rs.open "SELECT t1.Expr1,t2.Expr2, news_area.area_name,news_area.area_id FROM (SELECT area_id, COUNT(*) AS Expr1 FROM news WHERE (guest_aid >= 0) and (type_id>0) GROUP BY area_id) AS t1 inner JOIN news_area ON t1.area_id = news_area.area_id left outer JOIN (SELECT area_id, COUNT(*) AS Expr2 FROM news as news_1 WHERE (guest_aid >0) and (type_id>0) AND (promotion_end_date > '" & now() & "') GROUP BY area_id ) AS t2 ON t1.area_id = t2.area_id",conn,1,1
如何实现降序排列谢谢!
rs.open "SELECT t1.Expr1,t2.Expr2, news_area.area_name,news_area.area_id FROM (SELECT area_id, COUNT(*) AS Expr1 FROM news WHERE (guest_aid >= 0) and (type_id>0) GROUP BY area_id) AS t1 inner JOIN news_area ON t1.area_id = news_area.area_id left outer JOIN (SELECT area_id, COUNT(*) AS Expr2 FROM news as news_1 WHERE (guest_aid >0) and (type_id>0) AND (promotion_end_date > '" & now() & "') GROUP BY area_id ) AS t2 ON t1.area_id = t2.area_id",conn,1,1
如何实现降序排列谢谢!
比如按id降序排列，sql="select * from shuju order by id desc"
desc就是降序排列命令，在select最后面加上order by xx desc
xx你要降序排列的字段名
在sql 语句后面 加 order by id desc 意思是以id字段为准降序
order by id asc 意思是以id字段为准升序。
id你可以根据具体情况 换。