Index

Symbols

% (percent sign) wildcard, 41-42

[] (square brackets) wildcard, 44-46

^ (caret) wildcard character, 45

_ (underscore) wildcard, 43-44

| (pipe) symbol, 207

|| (double pipes), concatenation operator, 50

’ (single quotation mark), WHERE clause operators and, 30

* (asterisk) wildcard, queries, 17-18

*= (equality operator), 107

+ (concatenation operator), 50

+ (plus sign operator), outer joins, 107

, (comma), multiple column separation, 16

@ (at symbol) character, 158

@@ERROR variable, 167

@@IDENTITY global variable, 160

A

ABS( ) function, 64

Access (Microsoft)

DISTINCT argument support, 72

example tables for, 192

pass-through mode, 198

running, 197-198

sorting by alias, 82

stored procedure support, 154

aggregate functions

ALL argument, ...

Get Sams Teach Yourself SQL™ in 10 Minutes, Third Edition 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.