SQL rounding question
I have the following values returned in a column. 0.250000 and 13.000000. I would like to bypass 0.250000 to 1 and leave 13 as it is. Any easy way to do this since they both end up in the same column?
0
madcolor
source
to share
3 answers
Your DBMS probably has a CEILING function. Try it.
+2
Dave
source
to share
The ceiling function will work well because you want to round to the nearest whole number. More rounding methods with SQL Server ....
SQL Server rounding methods
+2
G mastros
source
to share
select CEILING (column name) from tablename
+1
Kieveli
source
to share