Jump to: navigation, search

Mysql SQRT

From w3cyberlearnings

Contents

MySQL SQRT Function

This function returns the square root of a positive X.

Syntax SQRT

X is a positive number.

SQRT(X);

Example 1

mysql> SELECT SQRT(4);
+---------+
| SQRT(4) |
+---------+
|       2 |
+---------+
1 row in set (0.00 sec)

Example 2

mysql> SELECT SQRT(25);
+----------+
| SQRT(25) |
+----------+
|        5 |
+----------+
1 row in set (0.00 sec)

Related Links


Navigation
Web
SQL
MISC
References