Explain how to use the SQRT function in Mysql _mysql

MySQL's sqrt function is used to compute any number of square roots. You can use the SELECT statement to find any number of square verification roots as follows:

Mysql> Select SQRT (a);
+----------+
| SQRT () |
+----------+
| 4.000000 |
+----------+
1 row in Set (0.00 sec)

The floating-point value you see, because internal MySQL handles the square root of the floating-point data type.

You can use the SQRT function to calculate the square root of a record. For more detailed use of the SQRT function, consider the EMPLOYEE_TBL table with the following records:

Mysql> SELECT * from EMPLOYEE_TBL;
+------+------+------------+--------------------+
| id |  name | work_date | daily_typing_pages
| +------+------+------------+--------------------+
|  1 | John | 2007-01-24 |        The |
|  2 | Ram | 2007-05-27 |        The |
|  3 | Jack | 2007-05-06 |        170 |
|  3 | Jack | 2007-04-06 |        |
|  4 | Jill | 2007-04-06 |        The |
|  5 | Zara | 2007-06-06 |        A |
|  5 | Zara | 2007-02-06 |        |
+------+------+------------+--------------------+
7 rows in Set (0.00 sec)

Suppose, based on the table above, to calculate the square root of all dialy_typing_pages, you can then use the following command:

mysql> SELECT name, SQRT (daily_typing_pages)
  -> from Employee_tbl;
+------+--------------------------+
| name | SQRT (daily_typing_pages) |
+------+--------------------------+
| John |        15.811388 |
| Ram |        14.832397 |
| Jack |        13.038405 |
| Jack |        10.000000 |
| Jill |        14.832397 |
| Zara |        17.320508 |
| Zara |        18.708287 |
+------+--------------------------+
7 rows in Set (0.00 sec)