Beginner

207. ROUND Function

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

📘 Lesson 207 of 728 ⏱ 8 min 🎯 Beginner

The ROUND function rounds a numeric value to a specified number of decimal places.

Financial and analytical reports often require values to be presented with a consistent number of decimal places.

Round an average salary to two decimal places.

SQL 
SELECT
    ROUND(AVG(Salary), 2) AS AverageSalary
FROM Employees;

ROUND is widely used in financial reporting, pricing, percentages, averages, and dashboard calculations.

  • ROUND changes the displayed numeric precision.
  • The number of decimal places can be specified.
  • It is useful for financial reporting.
  • It can be applied to calculated values.
  • Rounding behavior can vary for edge cases.
What does ROUND do?

ROUND rounds a numeric value to a specified number of decimal places.

Why use ROUND in reports?

It provides consistent numeric presentation and avoids displaying unnecessary decimal places.

Have you finished this lesson?

Introduction to SQL – All Lessons