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 
1Jenny 85.235 
2Bob 92.52 
3Alice 3.9 
4James 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

This page was last updated on April 30, 2022.




Copyright © 2022   1keydata.com   All Rights Reserved     Privacy Policy     About   Contact