Beginner

58. ROUND Function

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

📘 Lesson 58 of 728 ⏱ 7 min 🎯 Beginner

The ROUND function rounds a numeric value to a specified number of decimal places according to the database system's rounding rules. It is commonly used when displaying financial or analytical results.

Raw calculations can produce many decimal places that are unnecessary in business reports. ROUND helps create cleaner and easier-to-read results.

If a calculated profit margin produces 24.67891, ROUND can display it as 24.68 when two decimal places are required.

SQL 
SELECT
    ProductName,
    ROUND(ProfitMargin, 2) AS RoundedMargin
FROM Products;

ROUND is useful in financial reporting, sales analysis, pricing calculations, percentages, profit margins, and dashboard metrics.

  • ROUND rounds numeric values.
  • The number of decimal places can be specified.
  • ROUND is useful for presentation.
  • It is commonly used in financial calculations.
  • Rounding behavior can depend on the database system.
What does ROUND do in SQL?

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

Why is ROUND useful in reports?

It makes calculated numeric results easier to read by reducing unnecessary decimal places.

Have you finished this lesson?

Introduction to SQL – All Lessons