Kindly explain the output of the function
ROUND(45.923, -1)
The answer is being shown as 50
ROUND(45.923, -1)
The answer is being shown as 50
-
-
You're rounding to the nearest 10 by passing in -1. -
so if it is Round(42.365,-1) it will be rounded to 40 and not 50 right?Comment
-
Yes, but wouldn't it have been faster for you to run it and see the result rather than wait for someone to respond?Comment
-
Hi Rabbit,
Thanks for your reply.
The problem is that, neither I have SQL nor ORACLE installed in my system @ my workplace. If I had that I would not have started this thread.Comment
Comment