Using Numeric Functions in MySQL
Published September 13, 2026
By Sai Sree Ram Gundepudi
Examples
SELECT ROUND(123.456, 2);
SELECT CEIL(9.1);
SELECT FLOOR(9.9);
SELECT MOD(10, 3);
SELECT POWER(2, 3);