How to use the sql round field

The SQL ROUND() function rounds the number to the specified number of digits. It has two uses: 1. num_digits>0: rounded to decimal places; 2. num_digits

SQL ROUND() function detailed explanation

The SQL ROUND() function is used to round numbers to the specified number of digits. The basic syntax is:

 <code>ROUND(number, num_digits)</code>

in:

• number: The number to be rounded.
• num_digits: Specifies the number of bits rounded, which can be negative or positive.

Example of usage

The following table shows several examples of using the ROUND() function:

enter	num_digits	Output
123.4567	0	123
123.4567	2	123.46
123.4567	-1	120
123.4567	3	123.457

The difference between positive and negative num_digits

• num_digits > 0: Round the number to the specified decimal place. For example, ROUND(123.4567, 2) outputs 123.46.
• num_digits Round the number to the specified integer bit. For example, ROUND(123.4567, -1) outputs 120.

Use with caution

When using the ROUND() function, please note the following:

• This function only acts on numeric fields and is invalid for non-numeric fields.
• If num_digits is 0, the number is rounded to the nearest integer.
• If num_digits is negative, the number is rounded to the specified decimal place until the integer is reached.
• This function does not change the original number, but will only return the result after rounding.

The above is the detailed content of How to use the sql round field. For more information, please follow other related articles on the PHP Chinese website!