Hi Venkat, This is the best explanation that I came across about Recursive CTE. It will be a UNDERSTATEMENT to say "your tutorials are awesome or helpful" but rather I would say what ever I know of SQL server today is only because of your tutorials. I really owe a lot to you. Regards, Ayan
+Ayan Putatunda Thanks a million for taking time to give feedback. I am glad you found the videos useful. Free Dot Net & SQL Server videos for web developers th-cam.com/users/kudvenkatplaylists?view=1&sort=dd If you need DVDs for offline viewing, you can order them using the link below www.pragimtech.com/Order.aspx Code Samples, Text Version of the videos & PPTS on my blog csharp-video-tutorials.blogspot.com Tips to effectively use our channel th-cam.com/video/y780MwhY70s/w-d-xo.html Want to receive email alerts, when new videos are uploaded, please subscribe to our channel using the link below th-cam.com/users/kudvenkat Please click the THUMBS UP button below the video, if you think you liked them Thank you for sharing these links with your friends Best Venkat
when I first saw the video I had doubts to watch it, because I thought it is like other videos and don't have a deep explanation of how recursive works, but after watching I saw the differences and how clearly you explained this complex subject. THANKS VERY MUCH
I love your videos. I've been getting into SQL and every time I search something complex (like this--recursive queries) I always find your video among the top and it easily stands out. Your videos have stood the test of time (I'm finding them helpful in 2020). Also your voice is amazing - calm and gentle. Awesome work!
Truelly... I must say i became fan of yours and your tutorial.. To be very honest first time i understand preperlly this recursive CTE... 1000 Thumbs uppppp for this vedio from my side...
I had a few questions after watching your video: Recursive CTE in SQL Server part 51, but this made the concepts easier to understand. Thank you for the great videos, Venkat!
Sooooperb explanation..... watching part2 and even all the pre-requisites of part2 of this lecture series i was confused how does a recursive CTE work but after watching this part3 am crystal clear with this concept thank you so much sir..:)
Wow... This s useful video.. U r explaining clearly.. Still no one can do explain like you... Thank you so much of your explanation.. Now I clear abt the cute functionality
Hi Venkat Sir, You are doing a great Job by helping us all learn the complex concepts in a very simple manner. I don't Google for oracle/SQL server concepts, I directly come to your youtube channel. Thanks a ton :) Very very helpful videos.
Hi Venkat, Thank you for preparing these tutorials and videos. They have been very helpful in improving my understanding of the concepts. Concise and to the point with perfect explanation.
Everything is fine but you have not explained how the join statement is leading to the recursion. You have explained the steps being performed one after another but the role of the join statement has been left unexplained. Otherwise, it is a very nice video.
Thank you so much for all your tutorials, the most helpful I've ever seen and awesome for understanding! Looking forward to more series such as spark, ETL etc...
Thank you very much!!! Explained very good. But the issue is - according to your explanation we have to know which employee is on the lowest position in the hierarchy, and we don't have any indication for it. Because if you will choose employee id arbitrary then it will stop at Null without running across all rows. But we have indication for the highest hierarchy - boss_id is Null. So it is better to start with them and reverse the join on. with recursive EmployeeCTE as ( -- anchor select EmployeeId, EmployeeName, ManagerId from employees e where e.ManagerId is null union all -- recursive select e.EmployeeId, e.EmployeeName, e.ManagerId from employees e join EmployeeCTE eb on eb.EmployeeId = e.ManagerId ) select * from EmployeeCTE
Hello Venkat, I have learned a lot and in a much simpler way from your tutorials. I want to request you to help me understand how the levels are assigned to the hierarchy. Thank you :)
Hi , nice explanation In my case first select statement gives multiple rows and I have the ID of manager not the employee Example : I have ,ID of Ben as input and want to find all child employees I would need some help with that , could you pl guide me ?
Hi Venkat, thank you for making such easy to understand videos. Could you please make one video on recursive CTE to handle the case when employeeID and ManagerID are same?
Dear sir , The videos which you are uploaded is best of best. Requested to upload query optimization, complex query, performance tuning , trace, recovery of database , etc... video of real time example
Nice Video !!! I Like this and please make another video how to retrieve organization structure in reverse order. Example: By passing manager_id it should return list of subordinates.
Hi Venkat,
This is the best explanation that I came across about Recursive CTE. It will be a UNDERSTATEMENT to say "your tutorials are awesome or helpful" but rather I would say what ever I know of SQL server today is only because of your tutorials.
I really owe a lot to you.
Regards,
Ayan
+Ayan Putatunda Thanks a million for taking time to give feedback. I am glad you found the videos useful.
Free Dot Net & SQL Server videos for web developers
th-cam.com/users/kudvenkatplaylists?view=1&sort=dd
If you need DVDs for offline viewing, you can order them using the link below
www.pragimtech.com/Order.aspx
Code Samples, Text Version of the videos & PPTS on my blog
csharp-video-tutorials.blogspot.com
Tips to effectively use our channel
th-cam.com/video/y780MwhY70s/w-d-xo.html
Want to receive email alerts, when new videos are uploaded, please subscribe to our channel using the link below
th-cam.com/users/kudvenkat
Please click the THUMBS UP button below the video, if you think you liked them
Thank you for sharing these links with your friends
Best
Venkat
Without recursive :
Select emp.employeename,manager.employeename from Employee emp inner join Employee manager on emp.Managerid=manager.Employeeid
Cant believe that you gave this wonderful explanation before 6 years (2020 currently). The best youtube video I've ever seen.
2024 and still best
Hi Venkat, one word I can say about you, you are amazing man! Please dont stop SQL SERVER video tutorials
Dear Venkat, You are the best tutor ever exist on this planet!!
This was the most comprehensive explanation i've seen on this subject. You're the boss of bosses!
when I first saw the video I had doubts to watch it, because I thought it is like other videos and don't have a deep explanation of how recursive works, but after watching I saw the differences and how clearly you explained this complex subject. THANKS VERY MUCH
Absolutely wonderful explanation, Venkat. Even after 9 years there is nothing similar I found related to recursive CTE content.
Absolutely crisp and clear! Kudos, Venkat!
I love your videos. I've been getting into SQL and every time I search something complex (like this--recursive queries) I always find your video among the top and it easily stands out. Your videos have stood the test of time (I'm finding them helpful in 2020). Also your voice is amazing - calm and gentle. Awesome work!
I searched for this topic one hour all tutorials are just hard to understand but yours make it easy ...
Thanks...
I wish I had seen this tutorial before my last interview.
Thank you.
By FAR the best explanation I have seen about a topic. Thank you sr.
Tried many tutorials but this one is gem. God bless you Venkat. I have no words to admire you :)
The way you describes is just best . And you are Doing all the things for free . Thank you for all these Sir . 🙂
The best explanation on Recursive CTE, step by step !!
Truelly... I must say i became fan of yours and your tutorial.. To be very honest first time i understand preperlly this recursive CTE... 1000 Thumbs uppppp for this vedio from my side...
I love your videos. They are the best on the internet.
simply superb, i learnt sql in jus 2days...hatsoff bro..keep up the good work
I had a few questions after watching your video: Recursive CTE in SQL Server part 51, but this made the concepts easier to understand. Thank you for the great videos, Venkat!
Crystal clear explanation. Appreciate all your efforts in educating the community.
Bravo, now that’s how you break it down. Impressive. Thank you
This is exactly what I wanted to know when I watched the previous video and I was really happy when I just jumped into this video !!
Best recursive CTE explanation ever! Thanks!
thaaaaannnnkkk youuuuuu very much.. The way of your explanation with your soft voice is perfect...
Your way of explaining is amazing. Please keep posting all the SQL interview Q&A.
The best CTE explanation
Best explanation. Great Job and Thank you Venkat.
A simple way to explain a complex feature.
Thanks a lot
Anchor and recursive member... perfect, thanks for the walk through. Excellent line by line example.
Astig ng mga tutorial mo pre, more power sa channel mo ne, salamat!
This video is a treasure. It was massively helpful, thank you.
absolutelly best explanation ever
Kudos, one of the best in youtube
Sooooperb explanation..... watching part2 and even all the pre-requisites of part2 of this lecture series i was confused how does a recursive CTE work but after watching this part3 am crystal clear with this concept thank you so much sir..:)
I'm finally understanding recursive ctes. Thank you.
Sir Best explanation Recursive CTE. Best video (y).
Wow... This s useful video.. U r explaining clearly.. Still no one can do explain like you... Thank you so much of your explanation.. Now I clear abt the cute functionality
Hi Venkat Sir,
You are doing a great Job by helping us all learn the complex concepts in a very simple manner.
I don't Google for oracle/SQL server concepts, I directly come to your youtube channel.
Thanks a ton :)
Very very helpful videos.
Hi Venkat,
Thank you for preparing these tutorials and videos. They have been very helpful in improving my understanding of the concepts. Concise and to the point with perfect explanation.
Nice tutorial , Thank you Mr.Kudvenkat ❤️
Saying simple thanks is not enough for you, i am Nil in sql before watching this Pragim technologies SQL videos, now m almost clear sql.
Thank you very much Venkat , one of your best video, very complicated concept explained in a very understandable way .
Yes finally I got recursion in sql. thanks!
Thanks for the great explanation. This is best ever.....
wow this was super helpful!! Thanks a lot for explaining this in such simple way
This explanation is perfect. Thanks!!!
very nice explanation and would love your videos. Thanks Venkat
short and clear explanation on recursive CTE execution,
Thank you..
Everything is fine but you have not explained how the join statement is leading to the recursion. You have explained the steps being performed one after another but the role of the join statement has been left unexplained. Otherwise, it is a very nice video.
You are the best Venkat. Thanks
Nice Explanation ,Thank You Venkat Sir
Excellent! A very good explanation of recursive CTE's!
Thank you so much for all your tutorials, the most helpful I've ever seen and awesome for understanding! Looking forward to more series such as spark, ETL etc...
Thanks a million..You are the best tutor !!!!
Your videos are gems.
Thank you very much!!! Explained very good. But the issue is - according to your explanation we have to know which employee is on the lowest position in the hierarchy, and we don't have any indication for it. Because if you will choose employee id arbitrary then it will stop at Null without running across all rows. But we have indication for the highest hierarchy - boss_id is Null. So it is better to start with them and reverse the join on.
with recursive EmployeeCTE as (
-- anchor
select EmployeeId, EmployeeName, ManagerId
from employees e
where e.ManagerId is null
union all
-- recursive
select e.EmployeeId, e.EmployeeName, e.ManagerId
from employees e
join EmployeeCTE eb
on eb.EmployeeId = e.ManagerId
)
select *
from EmployeeCTE
Wonderful explanation for a concept which is not intuitive at all. Thanks a lot
well done again Venkat, very clear
Hi Venkat,
Love your explanation of recursive CTE, wonderful! LOVE IT!
Thx, now I understand how recursive cte works.
What a good job explaining this! Thanks so much!
Many thanks venkat ....awesome tutorials...
that explanation was excellent
thank you sir
exceptional definitive explain, thank you
Hi Venkat, good video to understand recursive cte ,thanks a lot for this
Recursive functionality explained clearly
Awesome.Thanks a lot for the great explanation.
Fantastic explanation, I now finally understand it!
Excellent work Sir🙏
Great Work Venkat
Really detailed and amazing explanation. Thank you so much for the tutorials!!
a nice explanation ! thank you, i'm from Viet Nam
Thank you Venkat. Very helpful.
Sir you are the best!
Very good explanation. Thanks!
thanks sir..this is very helpful tutorial......
I find your videos very helpful
Thanks for the great explanation
Thanks a lot for your tutorials..
Nicely explained , thanks n good job 👍
Thanks for the video Venkat, kindly upload video on Application Deployment and FileSystemWatcher Class.God bless you.
thanks you sir pl upload following concepts
what covariance vs contravariance in C#
How to Debug DLL C#
Paging in SQL
Crystal clear! Thank you!
Great explanation. Thank you!
sir thankyou so much ..........for the explanation
Hello Venkat,
I have learned a lot and in a much simpler way from your tutorials. I want to request you to help me understand how the levels are assigned to the hierarchy. Thank you :)
I would have liked it to be a bit more visual, showing the graphs at each step. Thanks for the effort though.
Best example on the net thanks
Thenx! The best explanation of CTE
Absolutely brilliant!!!!!! Thanks a million
Hi , nice explanation
In my case first select statement gives multiple rows and I have the ID of manager not the employee
Example : I have ,ID of Ben as input and want to find all child employees
I would need some help with that , could you pl guide me ?
Hi Venkat, thank you for making such easy to understand videos.
Could you please make one video on recursive CTE to handle the case when employeeID and ManagerID are same?
Dear sir ,
The videos which you are uploaded is best of best.
Requested to upload query optimization, complex query, performance tuning , trace,
recovery of database , etc...
video of real time example
superb explaination kep it up
Awesome explanation
Nice Video !!! I Like this and please make another video how to retrieve organization structure in reverse order. Example: By passing manager_id it should return list of subordinates.
Thanks for the video. 👍
I need to understand , how it works if anchor part or recursive part returns more than one row.🤔
Best explanation. Thanks.
Excellent. Thank you sir.
thanks you are the Best person ..........