X is a float and I need to perform x/10 and round the result up to the integer. So if result is 0.4 -> 1, if 1.1 -> 2.
How can I do this with SQL?
SELECTCEILING(X/10)AS numRoundup
FROM yourTable
No comments:
Post a Comment