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

用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"];
    }
?>