magento中使用group,order by,limit

magento中使用分组group

$collection->getSelect()->group('entity_id');  
$collection->groupByAttribute('entity_id');

对模型对应的表集合进行排序

$collection = Mage::getModel('module/model_name')->getCollection();  
$collection->getSelect()->order('last_name ASC'); 

对模型对应的表集合读取指定条数的数据记录

$collection = Mage::getModel('module/model_name')->getCollection();
$collection->getSelect()->limit($n);