How to Round up and Round-down value ??
I have value 3.74 Which should be round-down to 3.50 And
value 3.76 ,which should be round-up to 4.00
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Pankaj Kumar ChoudharyPosted Jun 30, 2015, 2:48 AM
WHEN NUM<3.76 THEN 3.50
ELSE 4.00 END
) FROM NUMBERS
Rajeesh MenothPosted Jun 30, 2015, 2:48 AM