SQL Cookbook

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

% (modulus) function (SQL Server), SQL Server, MySQL, MySQL

% (wildcard) operator, Solution

* character in SELECT statements, Retrieving Records

+ (concatenation) operator (SQL Server), SQL Server, SQL Server

A

abstraction, Paradoxes

ADDDATE function (MySQL), MySQL, MySQL, MySQL, MySQL

ADD_MONTHS function (Oracle), Oracle, Discussion, Oracle, Oracle, Oracle

aggregate functions

defining rows to perform operation on, Partitions, Partitions

grouping and, Relationship Between SELECT and GROUP BY, Windowing

multiple tables and, Problem

NULL values and, Problem, Paradoxes, Effect of NULLs

WHERE clause, Discussion

window functions versus, Windowing

aliases

for CASE expression, Problem

inline views, Discussion

timing of application, Discussion

any or "all" queries, Oracle

any or “all” queries, Answering Questions Involving “Any” or “All”, Answering Questions Involving “Any” or “All”, Discussion, Original solution, Question 13, DB2, Oracle, and SQL Server

arithmetic

dates

difference between dates, Problem

seconds/minutes/hours between dates, Oracle and SQL Server

AS keyword, Solution

at least queries, Answering Questions Involving “at Least”, Question 6, Question 7, MySQL ...