SQRT

Syntax

SQRT(X)

Description

Returns the square root of X. If X is negative, NULL is returned.

Examples

SELECT SQRT(4); +---------+ | SQRT(4) | +---------+ | 2 | +---------+  SELECT SQRT(20); +------------------+ | SQRT(20) | +------------------+ | 4.47213595499958 | +------------------+  SELECT SQRT(-16); +-----------+ | SQRT(-16) | +-----------+ | NULL | +-----------+  SELECT SQRT(1764); +------------+ | SQRT(1764) | +------------+ | 42 | +------------+

_{This page is licensed: GPLv2, originally from fill_help_tables.sql}