Learn From - Interactive SQL


Next Chapter »

SQL ROUND() Function


ROUND() function is used to round off the decimal places for the specified numeric Column in the database table.

SQL ROUND() Syntax


SELECT ROUND(column_name,decimals)
FROM table_name

Below is shown the "Orders" table:

OrderID CustomerID Date Amount
D001 C001 4/3/2007 12:00:00 AM 150.23
D002 C003 1/22/2005 12:00:00 AM 123.57
D003 C005 3/19/2003 12:00:00 AM 220.43
D004 C007 7/21/2008 12:00:00 AM 157.72
D005 C008 2/28/2009 12:00:00 AM 223.78
D006 C011 3/21/2005 12:00:00 AM 245.34

SQL ROUND() Example


Type or Copy the SQL into the Text Editor, click the "View Result" button, to see the result.

Round off the Amount column values to one decimal place in the Orders table.

Select ROUND(Amount,1) from Orders;

Round off the Amount column values to zero decimal place in the Orders Table.

Select ROUND(Amount,0) from Orders;

SQL in Text Editor:








Next Chapter »