Hi Gurus,
I've this Table cA
| ID_PRD | PRD_NAME | ID_ASSES | RESULT |
| 1 | Structure | 1 | 6 |
| 1 | Structure | 2 | 5 |
| 1 | Structure | 3 | 6 |
| 2 | Forme | 1 | 8 |
| 2 | Forme | 2 | 1 |
| 2 | Forme | 3 | 10 |
| 3 | Oragnize | 1 | 3 |
| 3 | Oragnize | 2 | 3 |
| 3 | Oragnize | 3 | 0 |
| 4 | Online | 1 | 6 |
| 4 | Online | 2 | 6 |
| 4 | Online | 3 | 6 |
I need to get the Variancde and / or Standard Deviation for "Result" group by ID_PRD
I mean, I would like to have something like this (Sorrythis values are aproximatif, I'vent done the exact calculs)
ID_PRD STDDEVI
1 0.2
2 0.9
3 0.9
4 0
Beacuse the STD DEVIATION For ID_PRD 4 is Zero, the variance between the values is null right?
But when I run the query suggest by Oracle
SELECTID_PRD,STDDEV(resultat) OVER (ORDER BY id_tp,id_asses) "StdDev"
from ASSES
i get quite different values
Does someone can Help?
Thxs in advance