O'Reilly logo

SQL in 24 Hours, Sams Teach Yourself, Sixth Edition by Ron Plew, Arie D. Jones, 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

accessing remote databases, 339-340

JDBC (Java Database Connectivity), 340

ODBC (Open Database Connectivity), 339-340

OLE DB, 340

vendor connectivity product, 340-341

Web interfaces, 341-342

adding

columns

auto-incrementing columns, 40-41

to tables, 40

time to dates, 186-187

addition, 128

ADMIN OPTION, 288

aggregate functions, 133-134, 334

AVG, 138-139

COUNT, 134-136

creating groups and, 147-150

DISTINCT, 141

MAX, 139-140

MIN, 140-141

SUM, 136-138

aliases, table aliases, 200

ALL, 118-120

ALTER ANY TABLE, 285

ALTER DATABASE, 285

ALTER TABLE, 39, 47, 357

ALTER USER, 285

ALTER VIEW, 300

altering

indexes, 250

users, 277-278

American National Standards Institute (ANSI), 2, 159

AND, 120-121

ANSI (American National Standards Institute), 2, ...

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