SQL in a Nutshell, 3rd Edition

Index

A note on the digital index

A link in an index entry is displayed as the section title in which that entry appears. Because some sections have multiple index markers, it is not unusual for an entry to have several links to the same section. Clicking on any link will take you directly to the place in the text in which the marker appears.

Symbols

“A Relational Model of Data for Large Shared Data Banks” (Codd), The Relational Model and ANSI SQL

A

abbreviations in identifiers, Naming conventions

ABS function, Numeric Scalar Functions

ABSTIME function, PostgreSQL, PostgreSQL-Supported Functions

access control, NULLs (rule 3)

ACOS function

MySQL, MySQL, Oracle, and PostgreSQL

Oracle, Oracle-Supported Functions

PostgreSQL, PostgreSQL-Supported Functions

SQL Server, SQL Server-Supported Functions

ADDDATE function, MySQL, Platform-Specific Extensions, MySQL-Supported Functions

addition arithmetic operator (+), Arithmetic operators, System delimiters and operators

+ (addition arithmetic operator), Arithmetic operators, System delimiters and operators

ADD_MONTHS function, Oracle, Oracle-Supported Functions

AES_DECRYPT function, MySQL, MySQL-Supported Functions

AES_ENCRYPT function, MySQL, MySQL-Supported Functions

AGE function, PostgreSQL, PostgreSQL-Supported Functions

aggregate functions, The GROUP BY clause, Window Functions

as window functions, Grouping or Windowing

AVG, ANSI SQL Aggregate Functions

CORR,

COUNT,

COVAR_POP,

COVAR_SAMP,

CUME_DIST, ,

DENSE_RANK, ,

MAX,

MIN,

PERCENTILE_CONT,

PERCENTILE_DISC, ...