Curriculum
Course: SQL
Login

Curriculum

SQL

SQL References

0/80

MySQL Functions

0/139

SQL Server Functions

0/84

SQL Quick Ref

0/1
Text lesson

SQRT

Example

Calculate and return the square root of a given number.

SELECT SQRT(64);

Definition and Usage

The SQRT() function calculates and returns the square root of a number.

Syntax

SQRT(number)

Parameter Values

 

Parameter

Description

number

Required: A positive numeric value from which to compute the square root.

 

Technical Details

Works in:

SQL Server (beginning from 2008), Azure SQL Database, Azure SQL Data Warehouse, and Parallel Data Warehouse

More Examples

Example

Calculate and provide the square root of a specified number.

SELECT SQRT(13);