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!
CTE is a feature where you give a name to a subquery to use in that query. A procedure or stored procedure is an object created on the database that can run a query or do more complex things involving variables and logic. A CTE does not create a database object, and a stored procedure is an object. A CTE exists only for a single query, and a stored procedure can be used in many places.
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.
Want to easily remember the SQL commands for your database? Get my free SQL Cheat Sheets here: www.databasestar.com/get-sql-cheat-sheets/?
This is such a clear, concise explanation for CTEs. Thank you so much!!!
Glad it was helpful!
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!
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.
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.
What is the difference between CTE and procedures?
CTE is a feature where you give a name to a subquery to use in that query. A procedure or stored procedure is an object created on the database that can run a query or do more complex things involving variables and logic.
A CTE does not create a database object, and a stored procedure is an object.
A CTE exists only for a single query, and a stored procedure can be used in many places.
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, 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.
Thanks. Great video!
Glad you liked it!
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.
please make a sequence of video play list
I've got a few playlists on my channel, which I am always adding to.
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!
A CTE cannot have indexes and constraints *beyond what already exists*
Good point!
Great
Thanks!