Using sub query for doubletts Follow @yiiframework

$model=new MyModel('search');
$model->unsetAttributes();
 
$criteria=new CDbCriteria();
$criteria->select='col1,col2,col3';
$criteria->group = 'col1,col2,col3';
$criteria->having = 'COUNT(col1) > 1 AND COUNT(col2) > 1 AND COUNT(col3) > 1';

$subQuery=$model->getCommandBuilder()->createFindCommand($model->getTableSchema(),$criteria)->getText();

$mainCriteria=new CDbCriteria();
$mainCriteria->condition=' (col1,col2,col3) in ('.$subQuery.') ';
$mainCriteria->order = 'col1,col2,col3';

$result = MyModel::model()->findAll($mainCriteria);
 
or
$dataProvider = new CActiveDataProvider('MyModel', array(
        'criteria'=>$mainCriteria,
));