Our Most Power Query Yet! Recursive CTE's (Common Table Expressions) | Essential SQL

If you're having troubles understanding how SQL recursive common table expressions work, then you'll want to watch this video. Learn more about SQL CTE's at www.essentialsql.com/introduc...
Recursive CTE's are useful for solving problems involving hierarchies such as manufacturing bill of materials or organizational charts.
Before you can dig into those complex queries let me help you make sure you got the basics down.
Most Business Analysts don’t know where to start learning SQL. At Essential SQL we have an easy-to-understand plan. You learn SQL frustration free, at the right time in the right order. Enroll today: www.essentialsql.com/landing/...

[@AbdulSamad-xe2xe]

Probably the most simplified explanation of recursive CTE,
Thanks a lot sir, keep the good work n stay safe.

[@EssentialSQL]

Thanks! I appreciate that!

[@theoemanuelsson7576]

Great video, thank you!

[@singhshobhit11]

I had no clue about RCTEs even after various tutorials but you really simplified it for me. Thanks a lot.

[@EssentialSQL]

My pleasure! I’m glad the video made it easier for you to understand recursive CTE’s

[@juliawenkmann8510]

Thank you, you're great! You helped me a lot! I finally got it!

[@EssentialSQL]

Glad I could help!

[@wennwenn1422]

How are recursive ctes evaluated? I was hoping for step by step approach. What does union all have to do with anything? Shouldn't anchor statement be called multiple times when recursive statement is called?

[@sujathapullareddy7726]

Thank you, very helpful.

[@michaelkoss]

Late to the party, but...
In your first example, your termination clause was "n < 10" and yet, you got 10 in your results. Can you explain why that is?
Fantastic video! Thank you so much. This really helped me understand (except the termination clause lol)

[@goforchuck]

I think it's because when it gets to the 9th iteration, 9 is still less than 10 and the query is selecting 9 + 1 for that iteration. The results include 1 because 1 is the "seed" value that is also being selected with the first select statement.

[@MrTokoFire]

Thanks for the video! How would you introduce a recursive starting at 0 and going by .125?

[@calvinbutler5517]

That was extremely helpful. Thank you much!

[@EssentialSQL]

Glad it was helpful!

[@EssentialSQL]

Awesome!

[@vamsireddy5051]

Great video, really helpful, Thanks 👍

[@EssentialSQL]

Glad it was helpful!

[@NIN1]

If using MySQL the syntax is
WITH RECURSIVE

[@EssentialSQL]

That for pointing that out! I find it interesting how each "dialect" is slightly different.

[@NIN1]

@@EssentialSQL thank you so much for the video!