SQRT function in mysql

By | January 18, 2014

see the example below

Select * from mydoubts_data

————————————-
|id | jobid | name | salary | age|
————————————-
|1 | 121 | vasanthan| 2000 |16 |
|2 | 122 | John | 3000 |64 |

select id,name,salary,SQRT(age) from mydoubts_data

——————————————-
|id | jobid | name | salary | SQRT(age)|
——————————————-
|1 | 121 | vasanthan| 2000 |4 |
|2 | 122 | John | 3000 |8 |