Question

What is the purpose of the ROUND(num, 0) in SQL, assuming num is a number with a fractional part?

Options

• Rounds the number to the nearest integer.

• Always rounds the number up.

• Leaves the number unchanged.

• Always rounds the number down.

Answer 1

Rounds the number to the nearest integer.

Explanation:

In SQL, the ROUND(num, 0) function rounds a number to 0 decimal places, i.e., to the nearest whole number.

• Example: ROUND(12.6, 0) → 13
• Example: ROUND(12.3, 0) → 12