O'Reilly logo

Oracle SQL by Carol McCullough-Dieter, Gavin JT Powell

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

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

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