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

回答1:

SELECT ROUND(2.2 * 2, 0) / 2 

gets you to the nearest .5