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 MS SQL Server

Review
So you think you can count?
Rounding functions and more
19. Numeric functions: FLOOR()
Review and practice

Instruction

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

Exercise

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).