MSSQL›Numeric Functions›ROUND
←FLOOR

ROUNDNumeric Functions

POWER→

Rounds or truncates to d decimal places.

Syntax

ROUND(n, d [, f])

Example

Enter values below to update the example in real time.

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