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
19. Rounding down
Review and practice

Instruction

Okay, that was the CEIL() function. Sometimes we need to round down, and the FLOOR(number) function will come in handy.

Exercise

Show each character's name, actual account_balance, and the account_balance rounded down as the balance_rounded_down column.

Stuck? Here's a hint!

Use the following expression: FLOOR(account_balance).