asp +sql server 统计排序

发布网友发布时间：2024-01-09 15:52

共2个回答

热心网友时间：2024-11-20 20:21

select (select cls_name from xzkj_class where [id]= classid) cls_name, count(*) '统计数' from xzkj_article group by classid order by '统计数' desc

这个是我拿我的数据库测试的，你更改下相关字段。

上面那个是对存在记录的栏目的统计，下面这个是对所有栏目的记录的统计。

select [id], cls_name,(select count(classid) from xzkj_article where classid=xzkj_class.[id])'统计数' from xzkj_class order by '统计数'desc

热心网友时间：2024-11-20 20:22

两个语句都可以，你自己换着试试，把栏目名字段自己换掉

<%
Set Rs=Server.CreateObject("ADODB.Recordset")
SQL = "select B.栏目名字段,count(*) as totle from news as A right join ClassList as B where A.parentid=B.id group by totle,B.栏目名字段 order by totle desc"
'或用下面这个语句
SQL = "select 栏目名字段,(select count(*) from news where news.parentid=id) as totle from ClassList order by totle desc"
Rs.Open SQL,Conn,3,2
If Not Rs.eof Then
Do while not rs.eof
Response.Write Rs(栏目名字段)&'新闻数量为'&Rs(totle)&'</br>'

%>