当前位置：
|
主题：[已答复]会员积分 投稿数排行怎么做呀？ [收藏主题] | 转到： |
 SQL类似这样：select top 10 username,Score,(select count(*) from ks_iteminfo where inputer=a.username) as num from ks_user a order by 3 desc,userid
|
|
 支持(1) |  反对(0)
 顶端  底部
|
![电子邮件:[ null_s@163.com ]](http://bbs.kesion.com/club/images/email.gif){kind=small}
![QQ号码:[ 2813239495 ]](http://bbs.kesion.com/club/images/qq.gif){kind=small}
 select top 10 username,Score,(select count(*) from ks_iteminfo where inputer=a.username) as num from ks_user a where a.groupid=用户组ID order by 3 desc,userid
试试这样 |
|
|
支持(0) | 反对(0)
顶端 底部
|
s elect中间空去掉 |
|
|
支持(0) | 反对(0)
顶端 底部
|
| ＜上一主题 | 下一主题 ＞ |