Itzik provides two examples of CTEs with multiple recursive members: genealogy-related queries and the nested set model for representing graphs.
seen from China

seen from United States
seen from United States
seen from Singapore

seen from United States
seen from United States
seen from United States

seen from China

seen from Switzerland
seen from Germany

seen from Switzerland
seen from Latvia

seen from United States
seen from Italy

seen from Malaysia
seen from China
seen from China
seen from Switzerland
seen from Uruguay
seen from China
Itzik provides two examples of CTEs with multiple recursive members: genealogy-related queries and the nested set model for representing graphs.