First page Back Continue Last page Overview Text


Recursive common table expression queries aren't the easiest things to write, especially for people who aren't used to getting their hands dirty with SQL. But they are often the best method to use in certain situations.

For example, if your employees table has a self referential supervisor_id column, using a recursive CTE is the way to go if you want to go all the way up or down the supervision chain.