<aside> 🔢 Number functions perform mathematical operations on numeric values.

</aside>

1. ROUND() — Round to Decimal Places

ROUND(number, decimal_places) — rounds number to the specified precision.

SELECT
    3.516            AS original_number,
    ROUND(3.516, 2)  AS round_2_decimals,
    ROUND(3.516, 1)  AS round_1_decimal,
    ROUND(3.516, 0)  AS round_to_integer

2. ABS() — Absolute Value

Returns the positive value of a number, ignoring the sign.

SELECT
    -10         AS original_number,
    ABS(-10)    AS absolute_neg,
    ABS(10)     AS absolute_pos

Other Common Math Functions

• CEILING(n) — Round up to the nearest integer
• FLOOR(n) — Round down to the nearest integer
• POWER(base, exp) — Raise base to the power of exp
• SQRT(n) — Square root
• MOD(a, b) — Remainder of a divided by b