Hi ,
I have a data set like
| Value1 | Value2 | Value3 | Value4 |
|---|
| 1 | 2 | 3 | 4 |
| 2 | 5 | 8 | 9 |
| 76 | 5 | 87 | 65 |
| 56 | 67 | 98 | 98 |
Now I need one more column at the end which will calculat ethe standard deviation of the 4th column with respect to the other columns of same row in the above order.
So the output will look like .
| Value1 | Value2 | Value3 | Value4 | Standard_Deviation |
|---|
| 1 | 2 | 3 | 4 | 1.29 |
| 2 | 5 | 8 | 9 | 3.16 |
| 76 | 5 | 87 | 65 | 36.61 |
| 56 | 67 | 98 | 98 | 21.55 |
I am using Oracle 11g. Please help.