Introduction
AN INTRODUCTION SHOULD give a noble purpose for writing a book. I should say that the purpose of this book is to help real programmers who have real problems in the real world. But the real reason this short book is being published is to save me the trouble of writing any more emails and posting more code on Internet Newsgroups. This topic has been hot on all the SQL-related websites and the solutions actually being used by most working programmers have been pretty bad. So why not collect everything I can find and put it in one place for the world to see?
In my book SQL For Smarties 2nd edition (Morgan-Kaufmann, 2000), I wrote a chapter on a programming technique for representing trees and hierarchies in SQL as nested sets. This ...
Get Joe Celko's Trees and Hierarchies in SQL for Smarties now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
