All Forums General
newton1965 12 posts Joined 06/13
05 Jan 2015
Sum Of Squares Operator

What is the Teradata operator equivalent for Excels SUMSQ (Sum of Squares)?
Thanks

Tags:
Raja_KT 1246 posts Joined 07/09
05 Jan 2015

Try with this example if I understand correctly. 
select  12**2------ ( 144)
select 12**3 -----(12*12*12)

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

newton1965 12 posts Joined 06/13
05 Jan 2015

That gives just the square root, but I did come up with a solution:
CAST (SUM(SQRT((AY - ABY)**2 + (AX - ABX)**2)) AS DECIMAL (8,2))
 
 

You must sign in to leave a comment.