Which of the following maths function in SQL returns the smallest integer greater than,
Which of the following maths function in SQL returns the smallest integer greater than,
or equal to, the specified numeric expression?
Show answerHide answer
Correct answer: (B) CEILING
Explanation
CEILING returns the smallest integer greater than or equal to the value, e.g. CEILING(4.2) = 5. FLOOR returns the largest integer less than or equal to it.