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

ROUND (expression, [decimal place])

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

Let's go through an example to see how the ROUND function is used. Let's assume we have the following table:

Table Student_Rating

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

SQL:

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

Result:

Example 2

SQL:

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

Result:

Link to this page: If you find this page useful, we encourage you to link to this page. Simply copy and paste the code below to your website, blog, or profile.

<a href="http://www.1keydata.com/sql/sql-round.html">SQL ROUND Function</a>

Copyright © 2012 1keydata.com   All Rights Reserved.         Privacy Policy