Question

What will be the result of the following SQL command?

SELECT ROUND(15.678, 2);

• A. 15.00
• B. 15.67
• C. 15.68
• D. 16.00

Hint:

Keep two decimal places. The third decimal digit is 8, so the second digit 7 is rounded up.

Answer 1

The Correct Option is C

Step 1: Recall what ROUND(x, d) does:
ROUND(x, d) rounds the number x to d places after the decimal point.
Here x = 15.678 and d = 2, so we keep two digits after the point.

Step 2: Look at the digit after the cut:
The number 15.678 has digits 6, 7, 8 after the point.
We keep 6 and 7. The next digit is 8, which is 5 or more, so we round the last kept digit up.

Step 3: Do the rounding:
15.67 becomes 15.68 because 7 goes up by 1.
So the command returns 15.68.

Step 4: Why the other options are wrong:
15.00 would mean the decimal part was thrown away. ROUND(15.678, 2) keeps two decimal digits, so it cannot give this.
15.67 comes from cutting the number (truncating) without rounding. MySQL ROUND does not truncate.
16.00 would be the result of ROUND(15.678, 0) shown with two decimals.

Final Answer:
The result is 15.68. This is option (C).