SQL

Numeric Functions

Perform mathematical operations on numbers.

By TechCoder TeamLast updated: 2026-06-02
In a Nutshell

Perform mathematical operations on numbers. This hands-on tutorial focuses on practical implementation of numeric functions concepts.

Math Functions

FunctionDescription
ABS(n)Returns the absolute value.
ROUND(n, d)Rounds number n to d decimal places.
RANDOM()Returns a random number.

Example: Rounding Prices

Round numeric values to 0 or 1 decimal places.

SQL PLAYGROUND
⏳ Loading editor…

Example: Random Numbers

Generate random numbers.

SQL PLAYGROUND
⏳ Loading editor…