Round, Ceiling and Floor Function in sql server

FLOOR(value) - Returning the largest integer less than or equal to the input value. The returning data type is the same as the input value.

CEILLING(value) - Returning the smallest integer greater than or equal to the input value. The returning data type is the same as the input value.

ROUND(value, 0, 0) - Returning the integer most close to the input value. The returning data type is the same as the input value.


SELECT FLOOR(1234.5658);
SELECT CEILING(1234.5658);
SELECT ROUND(1234.5658, 0, 0);

Output

1234
1235
1235.0000