Beginner

295. ROUND Function

Learn how to round numeric values to a specified number of decimal places.

📘 Lesson 295 of 728 ⏱ 9 min 🎯 Beginner

The ROUND function rounds a numeric expression to a specified number of decimal places according to the database system's rounding rules.

Business reports frequently require numbers to be displayed or calculated at a specific precision.

Round employee salary calculations to two decimal places.

SQL 
SELECT
    EmployeeID,
    ROUND(Salary / 12, 2) AS MonthlySalary
FROM Employees;

ROUND is commonly used in financial reporting, pricing, percentages, tax calculations, and dashboard outputs.

  • ROUND controls numeric precision.
  • It can round to decimal places.
  • The number of decimal places can usually be specified.
  • It is widely used in financial reporting.
  • Rounding rules can vary by database.
What does ROUND do?

ROUND rounds a numeric value to a specified level of precision.

Why is ROUND important in financial reports?

It helps present calculated amounts consistently at the required number of decimal places.

Have you finished this lesson?

Introduction to SQL – All Lessons