Question

can u please help me to understand ,round function in SQL ???? explain please...​

Answer 1

Answer:

hope this helps

Explanation:

In SQL Server (Transact-SQL), the ROUND function returns a number rounded to a certain number of decimal places.

You can use the ROUND function in excel for rounding numbers to a specified level of precision. ROUND can be used for rounding to the right or left of the decimal point. If num_digits is greater than 0, the number will be rounded to the specified decimal places to the right of the decimal point.

Identify which place value you are rounding to. The smaller the place value, the more accurate the final result will be.

Look to the next smallest place value, the digit to the right of the place value you're rounding to. For example, if you want to round to the nearest ten you'd look at the ones place.

If the digit in the next smallest place value is less than five (0, 1, 2, 3, or 4), you leave the digit you want to round to as-is. Any digits after that number (including the next smallest place value you just looked at) become zeros, or drop-off if they're located after the decimal point. This is called rounding down.

If the next smallest place value is greater than or equal to five (5, 6, 7, 8, or 9), you increase the value of the digit you're rounding to by one (+1). Just like before, any remaining digits before the decimal point become zeros, and any that are after the decimal point are dropped. This is called rounding up.

Answer 2

Explanation:

In SQL Server (Transact-SQL), the ROUND function returns a number rounded to a certain number of decimal places.Syntax

The syntax for the ROUND function in SQL Server (Transact-SQL) is:

ROUND( number, decimal_places [, operation ] )

Parameters or Arguments

number

The number to round.

decimal_places

The number of decimal places rounded to. This value must be a positive or negative integer. If this parameter is omitted, the ROUND function will round the number to 0 decimal places.