请问我这条SQL语句怎么修改好?
select top 10 typeid1,id from Boards group by typeid1 order by COUNT(typeid1) desc
select top 10 typeid1,id from Boards group by typeid1 order by COUNT(typeid1) desc
解决方案 »
- 有个问题图表的问题想麻烦大家
- 动态树的问题.....请高手指点..
- web安装项目 ,放上许可协议.rtf,显示还是显示不出来
- 做ASP.net的朋友,留个联系方式.
- 为什么没有ScriptLoadTimeout属性呢????急,请大家帮忙啊!!!!
- 程序多数时间正常,但有时莫名其妙的异常,是什么原因产生这样的异常。是否服务器设置的一些如内存限定等导致?
- ***高分求助!!!各位大侠帮帮忙!关于在.net里面使用SQL的transaction!!谢谢!!
- 如何修改Dataset中建立了联系的datatable的数据?
- 请问如何在DataGrid中某一列中显示复选框控件?
- 小问题
- Httpruntime的processRequest()方法
- 图片防盗链求助(有偿)紧急!~
select top 10 COUNT(typeid1),id from Boards group by typeid1,id order by COUNT(typeid1) desc
改成可运行的!
select top 10 COUNT(typeid1),id from Boards group by id order by COUNT(typeid1) desc
但是select top 10 typeid1,id from Boards group by typeid1 order by COUNT(typeid1) desc 这样写会报错 请问怎么写好呢
select top 10 typeid1,id from Boards 就可以了!!
不是 这句语句的意思是我即想排序又想查询出来
不是单单只查询就好
select top 10 typeid1,id from Boards g
inner join (select count(typeid1) as mm from Boards group by id) k
on k.id=g.id
oder by k.mm desc