REGR_SXX Function | VantageCloud Lake - REGR_SXX - Teradata Vantage

Teradata® VantageCloud Lake

Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
Language
English (United States)
Last Update
2024-04-03
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

Returns the sum of the squares of the independent_variable_expression for all non-null data pairs of the dependent and independent variable arguments.

For the REGR_SXX window function that performs a group, cumulative, or moving computation, see Window Aggregate Functions.

Computation

When there are fewer than two non-null data point pairs in the data used for the computation, then REGR_SXX returns NULL.

Division by zero returns NULL rather than an error.

ANSI Compliance

This statement is ANSI SQL:2011 compliant.