php怎么查询出重名用户月总积分 本帖最后由 chenxuezhi1986 于 2011-02-22 01:05:39 编辑 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 $sql = "select *,sum(myscore) as allscore from talbe group by id order by allscore desc"; select username,SUM(myscore) as score from tabletest group by username order by score desc 笔误 更正:$sql = "select *,sum(myscore) as allscore from talbe group by username order by allscore desc"; SELECT username,sum(myscore) as score FROM `test` GROUP BY username ORDER BY score DESC select 用户名,sum(积分)from xxxxgroup by 用户名order by 2 desc; 请教如何用php实现延时加载? 想请各位推荐一下html和css的教程 zend studio中和myeclipse中 对html的代码格式化 头疼啊 跪求大虾帮忙 mysql_connect()是如何找到mysql的 怎么能把fid添加到本条记录中 导航菜单问题! 关于在线支付 加减程序?急!急!急! 诚招版主 php+mysql 分页问题 php定时每天11:30在自动执行php程序代码? 变成伪静态后,是不是还要修改每个链接?
select username,SUM(myscore) as score from tabletest group by username order by score desc
$sql = "select *,sum(myscore) as allscore from talbe group by username order by allscore desc";
SELECT username,sum(myscore) as score FROM `test` GROUP BY username ORDER BY score DESC
from xxxx
group by 用户名
order by 2 desc;