Sandeep Bansal Sandeep Bansal - 1 month ago 7
SQL Question

Round to .5 or 1.0 in SQL

I'm looking to round values like


2.3913 -> 2.5

4.6667 -> 4.5

2.11 -> 2


How can I manage this in SQL?

Thanks

Answer
SELECT ROUND(2.2 * 2, 0) / 2 

gets you to the nearest .5

Comments