Joe Celko's SQL for Smarties, 5th Edition

Index

Note: Page numbers followed by f indicate figures and t indicate tables.

A

ActualSchedule table 94, 95t

Acyclic graphs, as nested sets 561–563

ADA language 797–798, 805

Adjacency list model 

graph 548

hierarchies 580–581

to nested sets model 561, 606–607

trees 580–581

Adjacency matrix model 563–564

AGE( ) function 753

Aggregate functions 439

AVG( ) function 446–451

CASE expression in 416

COUNT( ) functions 440–444

counting functions 440

extrema functions 451–459

LIST( ) 459–462

mathematical operations 440

median 463–465

mode 462–463

OUTER JOINs and 514

in OVERLAPS predicate 405

PRD( ) 465–470

SUM( ) function 444–446

window clause 483–484

windowed 654

Algol 495–496

Algorithms 

ascending order 531

descending order 531–532

Zeller’s algorithm  ...