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.