SQL Function For Rounding Decimal Numbers – Syntax

By | March 7, 2011

If you want to round a decimal number using SQL, use the ROUND() function of SQL.

SELECT ROUND(column_name,decimals) FROM table_name


SELECT itemName, ROUND(Price,2) as Price FROM Purchase

It will select itemName and Price from the table ‘Purchase’ and will Round the Price with 2 decimal places.


Leave a Reply

Your email address will not be published. Required fields are marked *