Sum Of Squares Operator

General

Sum Of Squares Operator

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

Thanks

Tags (1)
2 REPLIES

Re: Sum Of Squares Operator

Try with this example if I understand correctly. 

select  12**2------ ( 144)

select 12**3 -----(12*12*12)

Re: Sum Of Squares Operator

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))