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

Get Joe Celko's SQL for Smarties, 5th Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.