Subject Re: Standard Deviation calculation using select query ?
Author Ali Gökçen
Hi Mario,
my previous e-mail about alternate soluion lost in internet.

here is sql friendly new formula (one pass).

select sqrt( count(x)*sum(x*x)- sum(x)*sum(x) ) / count(x)
from mytable
where mydate>=?

Regards.

Ali