Re: Problem with built-in CORR function

>SELECT corr(x1,x2)
>FROM (
>SELECT t1.x x1,t2.x x2
>FROM mytable t1,mytable t2
>WHERE t1.NO = t2.NO AND t1.ID=1 AND t2.ID=2 ORDER BY t1.NO
>);

this is exactly what I needed. it calculates correlation correctly thanks! Received on Sun Apr 16 2006 - 12:01:07 CDT