Round the “Price” column to 1 decimal place in the “Products” table.
| SELECT ProductName, Price, Round(Price, 1) AS RoundedPrice FROM Products; |
The Round() function rounds a number to a designated number of decimal places.
|
Note: When the expression ends with a 5, this function rounds so that the final digit is an even number. For example:
|
| Round(expression, decimal_places) |
|
Parameter |
Description |
|
expression |
Specify the numeric expression to be rounded. |
|
decimal_places |
Optional. The number of decimal places to round the expression to. If omitted, the function rounds to the nearest whole number. |
|
WORKS IN |
From Access 2000 |