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!!
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.
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.
This is such a clear, concise explanation for CTEs. Thank you so much!!!
Glad it was helpful!
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!!
Thanks! Yes, it is trickier with a recursive CTE.
You know how to break this down so anyone (I'm 70) can learn. I will be back to your site to learn & grow. Thank you for sharing. East Coast Sr
Awesome, thank you!
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!
Thanks! That's a good point, I'll keep that in mind for future videos.
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.
Glad it was helpful! I can make a video about recursive in the future.
Thanks. Great video!
Glad you liked it!
Thanks, very helpful
Glad it was helpful!
great explanation. Love it.
Thanks!
Good Explanation.
Sir, Kindly make a video on Recursive Subquery Factoring in oracle. Thank you!
Thanks! Sure I can make a video on that.
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.
Thanks! I cover the difference between CTEs and Temp Tables in this video.
What is temp table ? does it mean View Table ?
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.
Thank so mach to day is Ethiopia new year that means 2017.
You're welcome!
please make a sequence of video play list
I've got a few playlists on my channel, which I am always adding to.
Great
Thanks!
A CTE cannot have indexes and constraints *beyond what already exists*
Good point!