I want a Sql query to round the prices
for example if the price is 5.01 then it should round it to 5 like wise we want to round the pennies. please send me a query for this. please let me know if my quey is correct , if not please correct it
update tablename set price=round(price,2) where pricelist='USD'