Depending on the database systems, the support for hierarchical queries significantly differ by. Hierarchical queries provides an overview on technical issues and approaches on this method.
See TPC-H section for detail.