Curriculum
Course: SQL
Login

Curriculum

SQL

SQL References

0/80

MySQL Functions

0/139

SQL Server Functions

0/84

SQL Quick Ref

0/1
Text lesson

CEIL

Example

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

SELECT CEIL(25.75); 

Definition and Usage

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

Note: This function is synonymous with the CEILING() function.

Syntax

CEIL(number)

Parameter Values

Parameter

Description

number

Necessary: A numerical value is required.

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 CEIL(25);