SQRT

All functions > MATH > SQRT

Returns the square root of a number.

Syntax

SQRT(number: T) → DOUBLE
sql

Type Parameters:

  • T: Any numeric type (TINYINT, SMALLINT, INTEGER, BIGINT, FLOAT, DOUBLE, DECIMAL)

Arguments

ParameterTypeRequiredDescription
numberTYesNon-negative number to find the square root of

Returns

DOUBLE - Square root result

Notes

  • Only defined for non-negative numbers (number >= 0)
  • SQRT(0) = 0
  • SQRT(1) = 1
  • SQRT(x²) = x for non-negative x
  • Returns NULL if input is NULL
  • Returns NaN for negative numbers
  • Equivalent to POW(number, 0.5)

Examples

Suggest changes to this page
Last update at: 2025/11/06 07:00:15
Last updated: 2025-11-06 07:00:51