Get Max and Min product Price in Magento

<?php  $db = Mage::getSingleton('core/resource')->getConnection('core_write');
$result = $db->query('SELECT price ,final_price, min_price, max_price, tier_price, group_price FROM catalog_product_index_price ORDER BY customer_group_id');

$result = $db->query('SELECT max(price) as max_price ,min(price)as min_price FROM catalog_product_index_price ORDER BY customer_group_id');




$rows = $result->fetch();


?>