SQRT

Description

Returns the square root of the specified float value. (SQRT in Transact-SQL).

Sample Source Pattern

Syntax

SQL Server

SQRT ( float_expression )  

Snowflake SQL

Snowflake SQL Documentation

SQRT(expr)

Examples

SQL Server

Code:

IN -> SqlServer_01.sql

SELECT SQRT(25) AS RESULT;

Result:

RESULT|
------+
   5.0|

Snowflake SQL

Code:

OUT -> SqlServer_01.sql

SELECT SQRT(25) AS RESULT;

Result:

RESULT|
------+
   5.0|