Why FLOOR function is used?

Answer:

FLOOR function is used to roundup a non integer number to the next least integer.
Syntax:-

FLOOR(expression) 

Example:-

SELECT FLOOR(355.34) FROM dual;

It will output 355. If we will pass a positive no. it will return only the integer part.

SELECT FLOOR(-355.34) FROM dual;

It will output -356. When we pass a negative value then it returns an integer less than the value passed.