Sams Teach Yourself SQL in 24 Hours, Fifth Edition

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 TABLE, 44, 264, 377

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), ...