// case 1
SomeActiveRecord::model()->findAll(array('order'=>'somefieldfield'));

// case 2
HistorialRanking::model()->findAll(
array(
"condition" => "tipo = 'karma' and fecha = date(now())",
"order" => "posicion desc"
)
);