ROUND Function in SQL Server - sql - sql tutorial - learn sql
- The ROUND function in SQL is used to round a number to a specified precision.
- The ROUND function returns a number rounded to a certain number of decimal places.
sql tutorial , pl sql tutorial , mysql tutorial , oracle tutorial , learn sql , sql server tutorialSyntax:
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.
Tags : sql tutorial , pl sql tutorial , mysql tutorial , oracle tutorial , learn sql , sql server tutorialExamples:
Examples:
- We use the following table for our examples.
Table Wikitechy_Student_Rating
| Column Name | Data Type |
|---|---|
| StudentID | integer |
| First_Name | char(20) |
| Rating | float |
- and this table contains the following rows:
Table Wikitechy_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 Wikitechy_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 Wikitechy_Student_Rating;
Result:
| First_Name | Rounded_Score |
|---|---|
| Jenny | 90 |
| Bob | 90 |
| Alice | 0 |
| James | 120 |