SQL for Smarties | SQL Programming Style | Trees and Hierarchies in SQL | SQL Puzzles and Answers | Data and Databases


Monday, July 03, 2006

Hierarchical Queries

SQL Apprentice Question
Does Sybase 11.9 support hierarchical queries?

Celko Answers
If you mean something likethe proprietary "hidden cursor" syntax in
Oracle, no thank god.

Get a copy of TREES & HIERARCHIES IN SQL for several pure SQL ways to
model trees and hierarchies along with all the code you will need.

No comments: