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
19. Numeric functions: FLOOR()
Review and practice


Okay, that was CEILING(), which always rounds up. Next comes FLOOR().


Show each character's name and actual AccountBalance, followed by the value in AccountBalance rounded down. Name the column DownBalance.

Stuck? Here's a hint!

Use FLOOR(AccountBalance).