Only this week, get the SQL Complete Track of 9 courses in a special prize of $330$89!
Introduction
1. Welcome
The very basics
Infinite looping
Processing trees with recursive CTEs
Processing graphs with recursive ctes
Summary

## Instruction

Hello and welcome to the fourth part of our course. Today, we're going to introduce the concepts of recursion and recursive CTEs; this is probably the most difficult part of our entire course. Don't worry if you can't understand something at first – take your time and read the instructions carefully again and again.

Recursive CTEs make it possible to process "hierarchical structures" – trees and graphs – using T-SQL. For instance, such structures are used when talking about superior and inferior employees, railway connections, application menus, etc.

If you're ready for the challenge, let's move on.

## Exercise

Click to continue.