Kickstart 2020 with new opportunities! - hours only!Up to 80% off on all courses and bundles.-Close
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).