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

[@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!

[@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.

[@parikshitr.rajpara5187]

very helpful video. perhaps the simplest explanation out of all the videos out there! Thank you so much!

[@shobhitrealm]

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

[@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?

[@juliawenkmann8510]

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

[@EssentialSQL]

Glad I could help!

[@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!

[@sujathapullareddy7726]

Thank you, very helpful.

[@theoemanuelsson7576]

Great video, thank you!

[@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!