Beginner

213. SQRT Function

Learn how to calculate the square root of a numeric value.

📘 Lesson 213 of 728 ⏱ 8 min 🎯 Intermediate

The SQRT function returns the square root of a numeric value in database systems that support the function.

Square-root calculations are useful in mathematical, statistical, and analytical calculations.

Calculate the square root of a numeric value.

SQL 
SELECT
    SQRT(144) AS SquareRoot;

SQRT can be used in statistical calculations, mathematical models, distance calculations, and analytical formulas.

  • SQRT returns a square root.
  • It is a mathematical function.
  • It is useful in analytical calculations.
  • Input requirements can vary by database.
  • It can be combined with other mathematical functions.
What does SQRT do?

SQRT returns the square root of a numeric value.

Where can SQRT be used?

It can be used in mathematical, statistical, and analytical calculations.

Have you finished this lesson?

Introduction to SQL – All Lessons