SQL > SQL Functions > ROUND Function

The ROUND function in SQL is used to round a number to a specified precision.

### Syntax

The syntax for the ROUND function is,

ROUND (expression, [decimal place])

where [decimal place] indicates the number of decimal points returned. A negative number means the rounding will occur to a digit to the left of the decimal point. For example, -1 means the number will be rounded to the nearest tens.

### Examples

We use the following table for our examples.

Table Student_Rating

 Column Name Data Type StudentID integer First_Name char(20) Rating float

and this table contains the following rows:

Table Student_Rating

 StudentID First_Name Rating 1 Jenny 85.235 2 Bob 92.52 3 Alice 3.9 4 James 120.1

#### Example 1: Decimal place is positive

To round to the nearest tenths place, we use the following SQL:

SELECT First_Name, ROUND (Rating, 1) Rounded_Score FROM Student_Rating;

Result:

 First_Name Rounded_Score Jenny 85.2 Bob 92.5 Alice 3.9 James 120.1

#### Example 2: Decimal place is negative

To round to the nearest tens place, we use the following SQL:

SELECT First_Name, ROUND (Rating, -1) Rounded_Score FROM Student_Rating;

Result:

 First_Name Rounded_Score Jenny 90 Bob 90 Alice 0 James 120

Next: SQL String Functions

Learn From Udemy: SQL For Data Science With Google Big Query 