Oracle-L: Re: Computing sum of squares

From: Ravi Sunkara <Ravi.Sunkara_at_KELLOGG.COM>
Date: Wed, 31 Jan 1996 09:42:10 -0500
Message-Id: <9601311747.AA13447@alice.jcc.com>

> Date: Tue, 30 Jan 1996 14:30:25 -0500
> From: AMY LEONE <AMY_LEONE_at_FMSO.NAVY.MIL>
> Subject: Computing sum of squares
>
> What is the best way to compute the sum of squares for a
> particular column over a group of rows? All answers
> appreciated.
>
> Amy

Try this....

SELECT SUM(POWER(col,2)) FROM table WHERE condition;

HTH Ravi Sunkara Received on Wed Jan 31 1996 - 12:47:20 CST