It is about Round Function Example and Usage in sql
First:Positive Number(it will be working left to right)
The answer is 1234.6000.Second number is 5.it is Equal to 5 so,adding one to the previous number.ie)previous number is 5+adding one number=6 The Another example:
The answer is 1235.0000.Second number is 5.so,adding one to the previous number.ie)previous number is 9+adding one number=10.it is two digit number.so it will adding tens number(ie 1) to the given number(before the decimal number)ie.1234+1=1235
The Another example:
Second:Positive Number(it will be working right to Left.it dont consider after the decimal numbers)
Which is Opposite to the Positive precision number.
First number is 4 which is less than 5,so it will round the number to zero.
First number is 9 which is Greater than 5,so it will round the number to 10.The ten's number one is added to the previous number.1239+1=1240
First number is 5 which is equal to 5,so it will round the number 5 to 10.The ten's number one is added to the previous number.1230+10=1240.0000
Third:precision number is zero
Thank you For reading my articles here.
if you have any queries please contact me in below mail and say your valuable comments here also.
My Mail Address is firstname.lastname@example.org
For more details, visit Rathin813.blogspot.com
1. It is really good information.
2. It provides all syntaxes related to the round function in sql