Page 6 - Consultas-SQL
P. 6
Finds the minimum value in a column given by
MIN(expression)
expression.
Finds the maximum value in a column given by
MAX(expression)
expression.
Generates a relative rank for a hypothetical row
PERCENT_RANK(value_list) WITHIN GROUP by dividing that row's rank less 1 by the number
(ORDER BY sort_list)
of rows in the group.
Generates an interpolated value that, if added
PERCENTILE_CONT (percentile) WITHIN
GROUP (ORDER BY sort_list) to the group, would correspond to the
percentile given.
Returns the value with the smallest cumulative
PERCENTILE_DISC (percentile) WITHIN distribution value greater than or equal to
GROUP (ORDER BY sort_list)
percentile.
Generates a rank for a hypothetical row
RANK(value_list) WITHIN GROUP (ORDER (value_list) in a group of rows generated by
BY sort_list)
GROUP BY.
Computes the average of the independent
REGR_AVGX(dependent, independent)
variable.
Computes the average of the dependent
REGR_AVGY(dependent, independent)
variable.
Counts the number of pairs remaining in the
REGR_COUNT(dependent, independent) group after any pair with one or more NULL
values has been eliminated.
Computes the y-intercept of the least-squares-
REGR_INTERCEPT(dependent,independent)
fit linear equation.
REGR_R2(dependent, independent) Squares the correlation coefficient.
Determines the slope of the least-squares-fit
REGR_SLOPE(dependent, independent)
linear equation.
REGR_SXX(dependent, independent) Sums the squares of the independent variables.
REGR_SXY(dependent, independent) Sums the products of each pair of variables.
REGR_SYY(dependent, independent) Sums the squares of the dependent variables.
Computes the population standard deviation of
STDDEV_POP(expression)
all expression values in a group.
Computes the sample standard deviation of all
STDDEV_SAMP(expression)
expression values in a group.
Computes the sum of column values given by
SUM(expression)
expression.
Computes the population variance of all
VAR_POP(expression)
expression values in a group.
Computes the sample standard deviation of all
VAR_SAMP(expression)
expression values in a group.
