SQL ROUND() Function

The ROUND() function is used to round a numeric field to the number of decimals specified.

SQL ROUND() Syntax

SELECT ROUND(column_name,decimals) FROM table_name

ParameterDescription
column_nameRequired. The field to round.
decimalsRequired. Specifies the number of decimals to be returned.


SQL ROUND() Example

We have the following "Products" table:
Prod_IdProductNameUnitUnitPrice
1Jarlsberg1000 g10.45
2Mascarpone1000 g32.56
3Gorgonzola1000 g15.67

Now we want to display the product name and the price rounded to the nearest integer.

We use the following SELECT statement:

SELECT ProductName, ROUND(UnitPrice,0) as UnitPrice FROM Products

The result-set will look like this:
ProductNameUnitPrice
Jarlsberg10
Mascarpone33
Gorgonzola16

No comments: