这个排序怎么排??asp的....

来源：百度知道编辑：UC知道时间：2024/05/24 06:52:22

sql="select gourl,count(gourl) as jls,sum(deng) as zcs from user where regtime like '%"&un&"%' group by gourl"

如何跟根sum(deng)由大到小排????

在后面加:order by sum(deng) desc

sql="select gourl,count(gourl) as jls,sum(deng) as zcs from user where regtime like '%"&un&"%' group by gourl" desc jls

你试试吧，我没测试。