Amazing. A+ explanation. My only feedback might be in your first example show the results of the subquery first, then show the whole query second. Cheers!
this really helped me learn about CTEs, so thank you very much!!! Now I just need to learn what "recursive" means and find your video on hierarchical queries.
The idea behind CTE is very clear and you have explained it very well. It just becomes tricky when this concept of recursion comes in.. Otherwise very good job done!!
hello there, god bless your efforts..I have a simple enquiry as new sql learner. How are CTEs different from temporary tables? Thanks for taking care of this.
It’s a table you can create to store data that you can refer to later. It’s like a view but it stores data and only exists for the duration of your session.