One of the usage of CTE is to determine the hierarchy where the depth is not known.

It allows you to traverse UP or DOWN in a recursive manner.