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