STDEV()

[Jon]

Hi All
I am trying to work out the standard deviation for all the columns in a
query not just 1 column.
Is there a way of selecting the full query and doing a stdev on it?

Yours Jon

[Tom van Stiphout]

On Fri, 30 Jan 2004 16:16:26 -0000, "Jon"
<jo**********@baesystems.com> wrote:

If I understand you correctly this should work:
select Field1 from MyTable
union
Select Field2 from MyTable
etc.

Then using this query, calculate the StDev.

BTW: There may be something wrong with your database design.

-Tom.

Hi All
I am trying to work out the standard deviation for all the columns in a
query not just 1 column.
Is there a way of selecting the full query and doing a stdev on it?

Yours Jon

[Jon]

Thanks Tom
Using a union worked

The reason it is checking several columns is we need to find the StDev for
several columns which hold a error value.

Ta Jon

Ps what does BTW mean?

"Tom van Stiphout" <to*****@no.spam.cox.net> wrote in message
news:aj********************************@4ax.com...

On Fri, 30 Jan 2004 16:16:26 -0000, "Jon"
<jo**********@baesystems.com> wrote:

If I understand you correctly this should work:
select Field1 from MyTable
union
Select Field2 from MyTable
etc.

Then using this query, calculate the StDev.

BTW: There may be something wrong with your database design.

-Tom.

Hi All
I am trying to work out the standard deviation for all the columns in a
query not just 1 column.
Is there a way of selecting the full query and doing a stdev on it?

Yours Jon