How to select DISTINCT of two columns from a table with condition in Yii?

Question

How to convert this sql statement to yii format build a model?

  SELECT  DISTINCT agency_id, university_id 
      FROM `tbl_universityagency` where agency_id=1

like this what I am missing? ,

$criteria = new CDbCriteria();
        $criteria->distinct=true;            
        $criteria->condition = "agency_id=".$result->agency_id ;         
        $modal=Universityagency::model()->find($criteria); 

Answer 1

$criteria = new CDbCriteria();
$criteria->distinct=true;
$criteria->condition = "agency_id=".$result->agency_id ;      
$criteria->select = 'id, agency_id, university_id';
$modal=Universityagency::model()->find($criteria);

Should produce query:

SELECT  DISTINCT id,agency_id, university_id FROM `tbl_universityagency` where agency_id=1 LIMIT 1