Learning SQL, 2nd 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

! (exclamation mark), != (not equal to) operator, Inequality conditions

% (percent sign), wildcard character in partial string matches, Using wildcards

' ' (quotes, single)

in strings, Including single quotes

surrounding strings, String Generation

' (apostrophe) in strings, Including single quotes

( ) (parentheses)

enclosing subqueries, What Is a Subquery?

ordering query combinations in compound queries, Set Operation Precedence

using with filter conditions, Using Parentheses

< (less than) operator

scalar subqueries and, Noncorrelated Subqueries

using with all operator, The all operator

<= (less than or equal to) operator, Noncorrelated Subqueries

<> (not equal to) operator

in inequality conditions, Inequality conditions

scalar subqueries and, Noncorrelated Subqueries

using with all operator, The all operator

= (equals sign)

= null, filtering for null values, Null: That Four-Letter Word

equal to operator

scalar subqueries and, Noncorrelated Subqueries

using with all operator, The all operator

using with any operator, The any operator

in equality conditions, Equality Conditions

> (greater than) operator

scalar subqueries and, Noncorrelated Subqueries

using with all ...