SQL Function For Rounding Decimal Numbers – Syntax

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

SELECT ROUND(column_name,decimals) FROM table_name

eg:

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.

🙂