Set limit on Magento Collection

-where $limit will be the number of results we want, $starting_from will be the index of the result set to be considered as starting point (note 0 is the index of first row) -this will ouptput 5 records starting from 3rd record

$limit = 5;  //limitation of prodect 
$starting_from = 2;  //which Prodect starting point
$product_collection = Mage::getModel('catalog/product')->getCollection()->setOrder('name', 'asc'); //getting the product collection, results are ordered by product name
foreach($product_collection as $_product)
    echo $_product->getName().'<br/>';