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. 🙂