Number Functions

ROUND: Rounds value to specified decimal places
TRUNC: Truncates value to specified decimal places (no rounding)
MOD: Returns remainder of division

Number Functions in SQL

Number functions perform operations on numeric values.

Function	Result	Description
ROUND(45.926, 2)	45.93	Rounds to 2 decimal places (standard rounding: 0.006 → up)
TRUNC(45.926, 2)	45.92	Truncates to 2 decimal places (cuts off excess without rounding)
MOD(1600, 300)	100	Returns remainder of 1600 ÷ 300 (1600 - 5×300 = 100)

DUAL is a dummy table that you can use to view results from functions and calculations.

alt text

alt text

For all nikovits.employees with job title of Sales Representative, calculate the remainder of the salary after it is divided by 5,000.

SELECT last_name, salary, MOD(salary, 5000)
FROM nikovits.employees
WHERE job_id = 'SA_REP';