SQL Reference Guide

Revision Time: 2 mins

6. Number Functions Reference

Common numeric functions.

ROUND()

Return: Value

Round numbers to decimal precision.

Syntax signature:ROUND(num, decimals)

Code snippet:

python

SELECT ROUND(avg_rating, 2) FROM reviews;

Expected Output:Rounded averages.

Remember: Always ensure correct syntax formatting when calling ROUND().

CEIL()

Return: Value

Round upward to nearest integer.

Syntax signature:CEIL(num)

Code snippet:

python

SELECT CEIL(price) FROM products;

Expected Output:Ceiling whole numbers.

Remember: Always ensure correct syntax formatting when calling CEIL().

FLOOR()

Return: Value

Round downward to nearest integer.

Syntax signature:FLOOR(num)

Code snippet:

python

SELECT FLOOR(price) FROM products;

Expected Output:Flooring whole numbers.

Remember: Always ensure correct syntax formatting when calling FLOOR().

ABS()

Return: Value

Return absolute positive values.

Syntax signature:ABS(num)

Code snippet:

python

SELECT ABS(balance_change) FROM transactions;

Expected Output:Absolute differences.

Remember: Always ensure correct syntax formatting when calling ABS().

MOD()

Return: Value

Modulo remainder check.

Syntax signature:MOD(num, divisor)

Code snippet:

python

SELECT MOD(id, 2) FROM users;

Expected Output:Remainders.

Remember: Always ensure correct syntax formatting when calling MOD().

POWER()

Return: Value

Exponential power values calculation.

Syntax signature:POWER(base, exp)

Code snippet:

python

SELECT POWER(10, 2);

Expected Output:100

Remember: Always ensure correct syntax formatting when calling POWER().

Previous Topic5. Date Functions Next Topic7. NULL Functions