It is used to find the round value of numerical column.
EmployeeID
|
EmployeeName
|
EmployeeSalary
|
1
|
Mayank Dixit
|
5000.89
|
2
|
Mona
|
4899.59
|
3
|
Purnima
|
4000
|
4
|
Payal
|
8000
|
employee
In the above table (employee), we want to return round value of numericalfield
(EmployeeSalary).
Syntax
SELECT Column Name1,
ROUND (Column Name2, 0) AS SubName
FROM TableName
Note : '0' define no value after decimal. in place of '0' may be 1 or 2 or any numerical value which define how much numerical value will take place after decimal.
Example
SELECT EmployeeName,
ROUND (EmployeeSalary, 0) AS RoundEmployeeSalary
FROM Employee
Here RoundEmployeeSalary is a subname (alias) of column.
Output:-
EmployeeID
|
EmployeeName
|
EmployeeSalary
|
1
|
Mayank Dixit
|
5001
|
2
|
Mona
|
4900
|
3
|
Purnima
|
4000
|
4
|
Payal
|
8000
|
