You can use hierarchical queries to retrieve data based on a natural hierarchical relationship between rows in a table