? MySQL Numeric Functions

? Quick Overview

MySQL Numeric Functions are built-in functions used to perform calculations, rounding, absolute values, random numbers, and mathematical operations on numeric data. They are commonly used in reports, analytics, billing systems, and financial calculations.

? Key Concepts

• Work with integers and decimal numbers.
• Used inside SELECT, WHERE, and expressions.
• Helpful for calculations and data analysis.
• Can be combined with other SQL functions.

? Common Numeric Functions

• ABS(): Returns the absolute value.
• CEILING() / CEIL(): Rounds up to the nearest integer.
• FLOOR(): Rounds down to the nearest integer.
• ROUND(): Rounds to a specified number of decimal places.
• TRUNCATE(): Truncates to a specified number of decimal places.
• MOD(): Returns the remainder of division.
• POWER(): Returns the value of a number raised to the power of another number.
• SQRT(): Returns the square root of a number.
• RAND(): Returns a random floating-point value between 0 and 1.

? Syntax & Theory

Numeric functions take numeric input and return a calculated numeric result. They can be applied directly to values or table columns.

? Code Examples

// Absolute value removes negative sign
SELECT ABS(-25);

// Rounds number to nearest integer
SELECT ROUND(12.6);

// Always rounds up to next integer
SELECT CEILING(4.2);

// Always rounds down to previous integer
SELECT FLOOR(9.9);

// Returns remainder of division (10 divided by 3)
SELECT MOD(10,3);

// Power calculation (2 to the power of 3)
SELECT POWER(2,3);

// Square root of a number
SELECT SQRT(81);

// Generates random number between 0 and 1
SELECT RAND();

// Truncate decimal without rounding
SELECT TRUNCATE(12.99, 0);

? Output & Explanation