Re: Standard Deviation - are there any existing SQL function

Norazman Sahir wrote:

> Hi,
>
> Again a very straight forward question.
> In Ms Access there is a built in function to calculate a standard
> deviation (ie DStDev & DStDevP)

> Does Oracle SQL also have one?
>

YES
> If so, can somebody give me the syntax examples...Thanks.

select stddev( sal )
from emp;

and

select variance( sal )
from emp;

See the group functions in your SQL*plus manual Received on Tue Dec 01 1998 - 10:12:39 CET