O'Reilly logo

Joe Celko's Thinking in Sets: Auxiliary, Temporal, and Virtual Tables in SQL by Joe Celko

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

11.1. Warm-up Exercises

The following mind games are to warm you up and see if you can think a little differently than the way you are used to thinking. I am assuming that the reader started his or her career as a procedural programmer and used sequential file systems for data. The classic structured programming constructs are IF-THEN-ELSE, WHILE-DO, and BEGIN-END, and they are what we have built programs from for decades. It is very hard to escape.

11.1.1. The Whole and Not the Parts

But perhaps the hardest thing to learn is thinking in sets. Consider this classic puzzle (Fig. 11.1).

Figure 11.1. Missing Bricks Puzzle

The usual mistake people ...

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