SQL ROUND Function

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

This page was last updated on June 19, 2023.

AdBlock Detected!

Our website is made possible by displaying ads to our visitors. Please supporting us by whitelisting our website.