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

Standard SQL Functions

Reviewing SQL and numbers
So you think you can count
Round and other functions
22. Function sqrt()
Review and practice

Instruction

Perfect. The last function we want to introduce is sqrt(x), which calculates the square root of x (\sqrt{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 it a try again.

Exercise

A nasty curse in our game changes your strength to its square root for a few minutes. Show each character's name, strength and calculate the square root of strength for each of them. Name the last column square_root.