Oracle›Numeric Functions›ROUND
←FLOOR

ROUNDNumeric Functions

TRUNC→

Rounds to d decimal places.

Syntax

ROUND(n [, d])

Example

Enter values below to update the example in real time.

salary→
avg_salary_k→
employees→
SELECT ROUND(AVG(salary), -3) AS avg_salary_k
FROM employees;