CEILING Function SQL server

Question

I was expecting the following SQL Query to return 1

SELECT CEILING(2/10)

However, it returns 0. Is there any way to get 1 from that SQL?

Answer 1

When we are using the SQL server calling function Return the smallest integer value that is greater than or equal to a number:

SELECT CEILING(25.75) AS CeilValue;

The CEILING() function returns the smallest integer value that is larger than or equal to a number.

Syntax

CEILING(number)