[FIXED] Using Yii Active Record to find max of one column

Issue

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

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

Answered By - Stephen305