ASP降序问题

    <%
  Sql="select top 8 * from NewsData where d_classid in (select classid from NewsClass where ParentID=16)"
Rs.Open Sql, conn, 1,1
Do Until Rs.Eof
  %>

怎样让他读取到数据库的降序ID呢
也就是让所有文章标题最新的始终在最前面

---

试试看
Sql="select top 8 * from NewsData where d_classid in (select classid from NewsClass where ParentID=16) order by id desc"

---

读出结果按 d_classid 字段降序排列...

<%
  Sql="select top 8 * from NewsData where d_classid in (select classid from NewsClass where ParentID=16) order by d_classid desc"
Rs.Open Sql, conn, 1,1
Do Until Rs.Eof
%>

---

Sql="select top 8 * from NewsData where d_classid in (select classid from NewsClass where ParentID=16) order by id desc"

---

dao!

---

<%
  Sql="select top 8 * from NewsData where d_classid in (select classid from NewsClass where ParentID=16) order by d_classid desc "
Rs.Open Sql, conn, 1,1
Do Until Rs.Eof
  %>

---

上面的方法都可以，试试吧

---

Sql="select top 8 * from NewsData where d_classid in (select classid from NewsClass where ParentID=16) order by id desc"