Multiple choice sql

What will be the output of the following statement? SELECT ROUND(123.89, -1)

  1. 120.00

  2. 123.00

  3. 123.90

  4. 124.00

Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

ROUND(123.89, -1) rounds to the nearest tens place because the second parameter is -1. 123.89 rounded to the nearest ten is 120, and the default precision for DECIMAL results in SQL Server is two decimal places, giving 120.00. A positive parameter would round to decimal places.