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 PostgreSQL

Review
So you think you can count?
Rounding functions and more
16. Precision in 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, 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).