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

<?php
$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
$product_collection->getSelect()->limit($limit,$starting_from);   
foreach($product_collection as $_product)
{
    echo $_product->getName().'<br/>';
}
?>