Using Yii Active Record to find max of one column

Question

How can I find max value of one column in database by Yii Active Record?

I can do it by pure sql and createCommand method,but I wanna do it by Active Record and CDbCriteria class.is there any way to do it?

Solution 1

You will want to change the select criteria as follows.

$model = new Model;
$criteria=new CDbCriteria;
$criteria->select='max(column) AS maxColumn';
$row = $model->model()->find($criteria);
$somevariable = $row['maxColumn'];

Reference:

http://www.yiiframework.com/forum/index.php/topic/6730-how-can-i-use-max-in-find-method/page_view_findpost_p_80659

Solution 2

This avoids creating an unnecessary temporary object:

$criteria = new CDbCriteria;
$criteria->select = 'max(column)';
// additional where conditions, if you so wish
$criteria->addColumnCondition(array('published' => 1));
$model = SomeModel::model();
$value = $model->commandBuilder->createFindCommand(
    $model->tableName(), $criteria)->queryScalar();

Solution 3

You can just limit the result and order by DESC e.g

$criteria = new CDbCriteria;
$criteria->order = 'column DESC';
$row = Model::model()->find($criteria);
$somevariable = $row->column;

Comments

[jsnfwlr]

This isn't flexible enough. If I had a table of users, with their age, weight, and height stored and wanted to select the top 10 tallest people and get the maximum weight for that subset, I couldn't extend your answer to get the results I wanted at all.