Curriculum
Course: MYSQL
Login

Curriculum

MYSQL

MySQL References

0/140
Text lesson

CEILING

Example

Provide the smallest integer value that is equal to or greater than 25.75.

SELECT CEILING(25.75); 

Definition and Usage

The CEILING() function yields the smallest integer value that is equal to or greater than a given number.

Note: This function is equivalent to the CEIL() function.

Syntax

CEILING(number)

Parameter Values

Parameter

Description

number

Mandatory: A numerical value is necessary.

Technical Details

Works in: From MySQL 4.0

More Examples

Example

Provide the minimum integer value that is equal to or greater than 25.

SELECT CEILING(25);