SQL ROUND()

The SQL math function ROUND() returns the number rounded to the given number of decimal places. If no decimal places are provided, the number is rounded without decimals.

Note: In some RDBMS like SQL Server, there may be an optional third parameter to truncate instead of round.

Syntax

ROUND(number, decimals)

Parameters:

• number: The number to be rounded.
• decimals (optional): The total number of decimal places to round to.

Return value:

Returns the number rounded to the given number of decimal places.

Example 1

In this example, the ROUND() function is used with a single argument:

SELECT ROUND(25.50);

Copy to clipboard
Copy to clipboard

The output this code generates is:

Note: When no decimal places are provided, ROUND() returns the nearest integer.

Example 2

In this example, the following data is given in the sales table:

The ROUND() function is used with the second optional argument decimals, setting the number of decimal places to 1:

SELECT id, ROUND(total, 1) AS total_rounded FROM sales;

Copy to clipboard
Copy to clipboard

This SQL statement rounds the total values and puts the results into a column named total_rounded using the AS keyword.

The output will be: