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 tutorial

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 tutorial

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

This tutorial provides more the basic needs and informations on sql tutorial , pl sql tutorial , mysql tutorial , sql server , sqlcode , sql queries , sql , sql formatter , sql join , w3schools sql , oracle tutorial , mysql , pl sql , learn sql , sql tutorial for beginners , sql server tutorial , sql query tutorial , oracle sql tutorial , t sql tutorial , ms sql tutorial , database tutorial , sql tutorial point , oracle pl sql tutorial , oracle database tutorial , oracle tutorial for beginners , ms sql server tutorial , sql tutorial pdf

Related Searches to ROUND Function in SQL Server

Adblocker detected! Please consider reading this notice.

We've detected that you are using AdBlock Plus or some other adblocking software which is preventing the page from fully loading.

We don't have any banner, Flash, animation, obnoxious sound, or popup ad. We do not implement these annoying types of ads!

We need money to operate the site, and almost all of it comes from our online advertising.

Please add wikitechy.com to your ad blocking whitelist or disable your adblocking software.

×