Numeric Functions – Ceil, Floor, Round

/*
  Ceil => CEIL(Number)
  number => Field Name
*/

SELECT number AS MainNumber, CEIL(number) AS newNumber FROM `try`;

/*
  Floor => FLOOR(Number)
  number => Field Name
*/

SELECT number AS MainNumber, FLOOR(number) AS newNumber FROM `try`;

/*
  Round => ROUND(Number, Decimal)
  number => Field Name
*/

SELECT number AS MainNumber, ROUND(number) AS newNumber FROM `try`;

SELECT number AS MainNumber, ROUND(number, 2) AS newNumber FROM `try`;