O'Reilly logo

Joe Celko's SQL for Smarties, 5th Edition by Joe Celko

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 24

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required