FirebirdSQL logo
 Built-in Scalar FunctionsWindow (Analytical) Functions 

VAR_SAMP Examples

select
  dept_no
  var_samp(salary)
from employee
group by dept_no
See also

[fblangref50-aggfuncs-var-pop], [fblangref50-aggfuncs-sum], [fblangref50-aggfuncs-count]

Linear Regression Aggregate Functions

Linear regression functions are useful for trend line continuation.The trend or regression line is usually a pattern followed by a set of values.Linear regression is useful to predict future values.To continue the regression line, you need to know the slope and the point of intersection with the y-axis.As set of linear functions can be used for calculating these values.

In the function syntax, y is interpreted as an x-dependent variable.

The linear regression aggregate functions take a pair of arguments, the dependent variable expression (y) and the independent variable expression (x), which are both numeric value expressions.Any row in which either argument evaluates to NULL is removed from the rows that qualify.If there are no rows that qualify, then the result of REGR_COUNT is 0 (zero), and the other linear regression aggregate functions result in NULL.