How to Round up and Round-down value

Question

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

Pankaj Kumar Choudhary · Answer

Hello @Amol you can use Case Expression for your query like as SELECT NUM=(CASE WHEN NUM ELSE 4.00 END ) FROM NUMBERS Output: If this is not as you except please inform me i will try again

Rajeesh Menoth · Answer

Hi Amol Khairnar  This one will help you : http://stackoverflow.com/questions/15810414/function-to-round-off-value-in-sql