Correct option is A
The ROUND function in SQL is used to round a numeric value to the specified precision.
· The second argument, -1, specifies rounding to the nearest
10s place.
· For 144.45:
· The digit at the 10s place is 4.
· Since the next digit (4) is less than 5, it is rounded
down to 140.
Important Key Points:
1. The ROUND function takes two arguments:
· The numeric value to be rounded.
· The number of digits to which the value should be rounded (negative values indicate places left of the decimal).
2. For positive numbers, a negative rounding position rounds to the left of the decimal point.
Knowledge Booster:
·
ROUND(148.21, -1): Results in
150, as the next digit (8) is greater than or equal to 5.
·
ROUND(144.45, 1): Results in
144.5, rounding to one digit after the decimal.
·
ROUND(144.45, 0): Results in
144, rounding to the nearest integer.