Index

; (semicolon), 7

<...> (angle brackets), 17–18

"" (double quotes, 78

/ (forward slash), 76

% (percentage character), 82, 102

| (pipe character), 18

_ (underscore character), 102

ABS function, 182

ADD_MONTHS function, 186

Aggregate functions

AVG, 238

CORR, 239

COUNT, 238

COVAR_POP, 239

COVAR_SAMP, 239

CUME_DIST, 240

defined, 176, 237

DENSE_RANK, 240

GROUP_ID, 240

grouping, 240

GROUPING(), 240

GROUPING_ID, 241

HAVING clause with, 255

MAX, 238

MEDIAN, 239

MIN, 238

Oracle, using, 238

PERCENTILE, 240

PERCENT_RANK, 240

RANK, 240

ranking, 240

REGR, 239

simple summary, 238

statistical calculators, 238–39

statistical distribution, 240

STATS, 239

STDDEV, 238

STDDEV_POP, 238

STDDEV_SAMP, 239

SUM, 238, 242

VARIANCE, 238

VAR_POP, 239

VAR_SAMP, 239

Get Oracle SQL 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.

Start your free trial