Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

Common Functions in MS SQL Server

Review
So you think you can count?
Rounding functions and more
17. Precision in ROUND()
Review and practice

Instruction

Good!

What happens if the second argument in ROUND() is set to anything other than zero?

The second argument specifies the number of decimals to be returned. For example:

SELECT ROUND(136.123, 2);

will return 136.120.

Let's try this out.

Exercise

Show each character's name, its actual AccountBalance, and the AccountBalance rounded to a single decimal place. Name the column RoundedBalance.

Stuck? Here's a hint!

Here, you'll need ROUND(AccountBalance, 1).