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

Instruction

Perfect!

The last function we want to introduce is SQRT(x), which calculates the square root of x (that is √x).

SELECT SQRT(25);

The square root of 25 is 5, and this is the result we'll get from the above query.

Let's give this function a go as well.

Exercise

A nasty curse in our game changes a character's strength to its square root for a few minutes.

Show each character's name, strength, and the square root of their strength. Name the column CursedStrength.

Stuck? Here's a hint!

You need SQRT(Strength).