O'Reilly logo

Sams Teach Yourself SQL in 24 Hours, Fifth Edition by Arie D. Jones, Ron D. Plew, Ryan Stephens

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required