Sams Teach Yourself SQL in 10 Minutes a Day, 5th Edition

Index

A

aggregate functions, 79–80

AVG(), 80–81

combining, 86–87

COUNT(), 81–82

DISTINCT keyword, 85–86

MAX(), 82–83

MIN(), 83–84

performing on distinct values, 85–86

SUM(), 84–85

using with joins, 123–124

aliases, 63–65

naming, 87

table, 117–118

ALL clause, 91

ALTER TABLE statement, 155–157, 196

syntax, 209

Analysis icon, 3

ANSI SQL, 10

controlling transactions, 182

inner join syntax, 113

application filtering, 34

arguments. See also keywords

DISTINCT, 85–86

asterisk (*) wildcard, 17

authentication, 202

authorization, 202

AVG() function, 80–81

DISTINCT keyword, 85–86

B

binary datatypes, 219

brackets ([]) wildcard, 55–57

breaking up data, 7

C

calculated fields, 59–60

concatenating fields, 60–63

performing mathematical calculations, 65