REGR_SXX Function | Teradata Vantage - 17.10 - REGR_SXX - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - SQL Functions, Expressions, and Predicates

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)

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.


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 results in NULL rather than an error.