Index
A
ABS (absolute value), 183
accessing remote databases, 357–358
JDBC, 358
ODBC (Open Database Connectivity), 358
OLE DB, 359
through web interfaces, 359–360
vendor connectivity products, 359
adding
auto-incrementing columns to tables, 45
columns to tables, 44–45
time to dates, 196–197
addition, arithmetic operators, 133–134
ADMIN OPTION, 305
aggregate functions, 141–142
AVG, 146–147
COUNT, 142–145
creating groups, 155–158
MAX, 147–148
MIN, 148–149
SUM, 145–146
ALL, 124–126
ALTER ANY TABLE, 302
ALTER DATABASE, 302
ALTER USER, 302
altering
indexes, 263
users, 294–295
American National Standards Institute. See ANSI (American National Standards Institute)
AND, 126–127
ANSI (American National Standards Institute), ...
Get Sams Teach Yourself SQL in 24 Hours, Fifth 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.