'Decimal Round figure Condition

enter image description hereI want to round the figure of "Rate" if the decimal value becomes .5 or higher (For Example if 17.57 I want it as 18, if 20.98 I want it as 21)

On the other hand, if the decimal value becomes lower than .5 (For Example if 17.23 I want it as 17, if 20.49 I want it as 20) I am attaching an image. Please let me know the condition.Thank you.

sqlsql-serverdatabase


Solution 1:[1]

You just need use Round() function as below:

select round(86.54,0) //zero will fix in your case

Solution 2:[2]

Use round function

select round('19.6',0)

Result

enter image description here

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1
Solution 2 Moulitharan M

Related Questions