SQL ROUND() Function

From http://www.w3schools.com (Copyright Refsnes Data)

# 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

From http://www.w3schools.com (Copyright Refsnes Data)