Advance Descriptive Statistics
Abstract
SQL added descriptive stats to Standard SQL. This makes more elaborate reporting possible.
Keywords
SQL:2006
ALL
DISTINCT
CORR
Correlation coefficient
COVAR_POP
Population covariance
COVAR_SAMP
Sample covariance
Covariance
CUME_DIST
DISTINCT
PERCENTILE_CONT
PERCENTILE_DISC
Population
Population variance
REGR_AVGX
Average of independent variable
REGR_AVGY
Average of dependent variable
REGR_COUNT
REGR_INTERCEPT
y-intercept
REGR_R2
Square of correlation coefficient
REGR_SLOPE
Slope of least-squares-fit linear equation
REGR_SXX
Sum of squares of independent variable expression
REGR_SXY
Sum of products
REGR_SYY
Sum of squares of dependent variable expression
STDDEV_POP
Population standard deviation ...
Get Joe Celko's SQL for Smarties, 5th Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
