Articles/SQL

CEIL() in MySQL — How It Works

What the MySQL CEIL() function does, with an example.

Published October 21, 2026

CEIL() rounds a number up to the nearest integer.

Key points

  • Part of standard SQL functions available in MySQL for working with query results

Example

SELECT CEIL(19.1);  -- 20
More SQL articles