What does round mean in sql

ROUND meaning in SQL

In SQL, the ROUND function is used to round a number to a specified number of decimal places. This function rounds a number according to the specified number of digits and returns the result as output.

Syntax

ROUND(number, decimal_places)

Where:

• number: The number to be rounded.
• decimal_places: Specifies the number of decimal places to round to.

Example

To round the number 123.4567 to two decimal places, you can use the following query:

SELECT ROUND(123.4567, 2);

Output:

123.46

Rounding rules

ROUND function follows standard rounding rules:

• If the number after the rounding digit is greater than or equal to 5, then round The position increases by 1.
• If the number following the rounding digit is less than 5, the rounding digit remains unchanged.

Note

• If the specified number isNULL, the ROUND function returnsNULL.
• If the specifieddecimal_placesis a negative number, the ROUND function returns the input number itself (unrounded).
• If the specifieddecimal_placesis greater than the number of decimal places of the input number, the ROUND function returns the input number directly.

The above is the detailed content of What does round mean in sql. For more information, please follow other related articles on the PHP Chinese website!