SQL ROUND() Function
The 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 |
Parameter |
Description |
column_name |
Required. The field to round. |
decimals |
Required. Specifies the number of decimals to be
returned. |
SQL ROUND() Example
We have the following "Products" table:
Prod_Id |
ProductName |
Unit |
UnitPrice |
1 |
Jarlsberg |
1000 g |
10.45 |
2 |
Mascarpone |
1000 g |
32.56 |
3 |
Gorgonzola |
1000 g |
15.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:
ProductName |
UnitPrice |
Jarlsberg |
10 |
Mascarpone |
33 |
Gorgonzola |
16 |
|