Joe Celko's SQL Puzzles and Answers

This little collection of puzzles is something to bash your head against while awaiting your SQL epiphany.
--Joe Celko

Joe Celko challenges you with his trickiest puzzles and then helps you conquer them with a variety of solutions and explanations. The puzzles are a compilation from Joes columns in DBMS and Database Programming & Design magazines. They include new, never-before-published puzzles plus new solutions and extra background for previously published puzzles. In his usual entertaining and informative style, Joe demonstrates the thought processes that are involved in attacking a problem from an SQL perspective. Through the practical, enjoyable puzzles, he introduces immediately useful new techniques and applications for SQL programming, and shows the database programmer how to write and use non-procedural programs.

Authors:

About the author:

Joe Celko (Northern Lights Software) is a noted consultant, lecturer, teacher and columnist, and winner of the 1996 DBMS Reader's Choice Award for Best Column. He is well known for his dependable help on the DBMS CompuServe Forum and for his use of entertaining anecdotes and war stories to provide real-world insight into SQL Programming.

Table of Contents:

Chapter 1: Defining Data
Chapter 2: Formatting Data
Chapter 3: Selecting Data
Chapter 4: Computing Things
Chapter 5: Grouping Data

Related Titles:

Database
Information Technology
Software Engineering & Programming