怎么对数据库查询进行group by 和sum 操作

分享一下我老师大神的人工智能教程！零基础，通俗易懂！http://blog.youkuaiyun.com/jiangjunshow

也欢迎大家转载本篇文章。分享知识，造福人民，实现我们中华民族伟大复兴！

                用AR方式实现：
1.直接用findall
$result = Test::model()->findAll(array('select'=>'name, sum(record) as summary','group'=>'category'));


2.在model relation里声明一个聚合数据
public function relations() {
      'childrenSum'=>array(self::STAT,'Test','pid','select'=>'sum(pid)'),

}

-------------------------------------------

iya, saya juga berfikir demikian, 

mungkin bisa pula melalui findAllBySql() http://www.yiiframework.com/doc/api/1.1/CActiveRecord#findAllBySql-detail

<?php    $sql="        SELECT                A.id,                 sum(B.price) as Total,                 count(B.B_id) as jumlah,                 max(B.price) as maks,                 min(B.price) as Min        FROM                 A INNER JOIN B ON A.ID=B.A_ID        ";    $data = A::model()->findAllBySql($sql);    foreach ($data as $dataItem)    {        echo $dataItem['id'];        echo "Total = ".$dataItem['Total'];        echo "Count = ".$dataItem['jumlah'];        echo "Min = ".$dataItem['Min'];        echo "Max = ".$dataItem['maks'];    }?>

           

给我老师的人工智能教程打call！http://blog.youkuaiyun.com/jiangjunshow