mysql的group by ,order by语句的使用

Ethanhuyi

于 2016-11-23 21:29:54 发布

阅读量418

点赞数 1

分类专栏： mysql

本文链接：https://blog.csdn.net/will5451/article/details/53312122

版权

mysql 专栏收录该内容

44 篇文章 0 订阅

订阅专栏

select uin, zone_id, max(totalCount) as a, max(totalMoney) as b from (select uin, zone_id, count(1) as totalCount, sum(money) as totalMoney from fd_sendprize_log group by zone_id, uin) as A group by zone_id order by b desc, a desc;

问题：

发将表：选出将各个大区中抽奖次数最多，获得奖励最高的玩家uin

select uin,zone_id,coun(*) as count,sum(money) as total from fd_sendprize_log group by zone_id,uin;

其中的group by的使用方法可以 group by zone_id,uin 先按区排再按uin玩家账号排

group by的使用方法和order by 使用方法是一致的.

/*
 * 每个大区抽奖次数最多的玩家次数，以及获取的51点数目
 */
//$sqll                              = "select uin,zone_id,count(*) as count,sum(quantity) as totalMoney from fd_sendprize_log group by zone_id,uin";
$sql2                              = "select uin,zone_id,max(totalCount) as maxTimes  from (select uin,zone_id,count(*) as totalCount,sum(quantity) as totalMoney from fd_sendprize_log group by zone_id,uin) as A group by zone_id order by maxTimes desc";
$zoneCount                         = $this->model->query_sqls($sql2); //每个大区次数最多的玩家
$sql2                              = "select uin,zone_id,max(totalMoney) as maxMoney  from (select uin,zone_id,count(*) as totalCount,sum(quantity) as totalMoney from fd_sendprize_log group by zone_id,uin) as A group by zone_id order by maxMoney desc";
$zoneMoney                         = $this->model->query_sqls($sql2); //每个大区获取51点最多的玩家