SQL getting started Tutorial: SQL ROUND () instance tutorial

SQL getting started Tutorial: SQL ROUND () instance tutorial

Round () function
The round () function is used to specify Decimals in a numerical field.

Database round () syntax

SELECT ROUND(column_name,decimals) FROM table_name

Let's take a look at the data structure.

 
 

  
  
 
   
 
    
Parameter
 
    
Description
 
   
 
   
 
    
column_name
 
    
Required. The field to round.
 
   
 
   
 
    
decimals
 
    
Required. Specifies the number of decimals to be returned.
 
   
 
  
 
 

Instance tutorial.

 
 

  
  
 
   
 
    
Id
 
    
ProductName
 
    
Unit
 
    
UnitPrice
 
   
 
   
 
    
1
 
    
Jarlsberg
 
    
1000 g
 
    
10.45
 
   
 
   
 
    
2
 
    
Mascarpone
 
    
1000 g
 
    
32.56
 
   
 
   
 
    
3
 
    
Gorgonzola
 
    
1000 g
 
    
15.67
 
   
 
  
 
 

Now, we want to display the product name and price rounded to the nearest integer.

We use the following SELECT statement:
SELECT ProductName, ROUND(UnitPrice,0) as UnitPrice FROM Persons
 
Output result.
  
  

   
   
 
    
 
     
ProductName
 
     
UnitPrice
 
    
 
    
 
     
Jarlsberg
 
     
10
 
    
 
    
 
     
Mascarpone
 
     
33
 
    
 
    
 
     
Gorgonzola
 
     
16