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

Standard SQL Functions

Reviewing SQL and numbers
So you think you can count
Round and other functions
15. Precision with round()
Review and practice

Instruction

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.

Exercise

Show each character's name together with its original account_balance and account_balance rounded to a single decimal place (name this column rounded_account_balance).

Stuck? Here's a hint!

Here, you'll need round(account_balance, 1).