Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
So you think you can count?
Rounding functions and more
16. Precision in ROUND()
Review and practice


Good! There is also another version of round, which takes two arguments: ROUND(x, precision). The second argument is new and specifies the number of decimal places to be returned. For example,

SELECT ROUND(136.123, 2);

will return 136.12. Let's try it out.


Show each character's name, its actual account_balance, and the account balance rounded to a single decimal place as the rounded_balance column.

Stuck? Here's a hint!

Here, you'll need this expression: ROUND(account_balance, 1).