O'Reilly logo

Effective SQL: 61 Specific Ways to Write Better SQL, First Edition by Ben G. Clothier, Douglas J. Steele, John L. Viescas

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

Symbols

& (ampersand) operator, concatenation symbol, 24, 249

+ (plus sign) operator, concatenation symbol, 24, 249

|| (vertical bars) operator, concatenation symbol, 24, 248249

A

Absent data. See Null values.

Access

choosing a primary key, 88

Edit Relationships dialog box, 64

execution plans, 204205, 212

ignoring columns, 8788

importing data, 8687

naming tables, 88

support for CTEs, 249

tools, 8689

unpivoting sales data, 8889

upsizing from, 6364

Access, date and time

arithmetic operations, 303304

data types, 303

functions, 304305

Accumulating snapshot fact tables, 46

Adjacency list model, hierarchical data, 286288

Age calculation, SQL code example, 113

Aggregation

counting items in a group, 156159

distinct counts, 163166

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