麻烦高手帮我改一下这个asp代码???在线等

来源：百度知道 编辑：UC知道 时间：2024/05/19 04:22:28
sql="select 用户,count(用户) as jls,sum(次数) as zcs from user where regtime like '%"&un&"%' group by 用户"

这样的代码如何改成按上面sum(次数)得出的结果从大到小排序

my god!!
group by绝对是不能和where一起用的！！

select 用户2,count(用户2) as jls,sum(次数2) as zcs
from (select 用户 as 用户2, 次数 as 次数2 user where regtime like '%"&un&"%' )
group by 用户2

这样应该可以

sql="select 用户,count(用户) as jls,sum(次数) as zcs from user where regtime like '%"&un&"%' group by 用户 order by zcs desc"