Recursive SQL Queries Tutorial | Learn to write SQL Queries using Recursion

Подписаться 330 тыс.

Просмотров 213 тыс.

50% 1

Visit brilliant.org/t... to get started learning STEM for free, and the first 200 people will get 20% off their annual premium subscription.
All the scripts and dataset used in this video can be downloaded for free from my discord. Link to join my discord below:
Discord link: / discord
In this video, let's learn how to write Recursive SQL Queries. Learn to write SQL Queries using Recursion by solving different SQL queries. This video will explain the syntax to be followed to write recursive sql queries and we shall look at the difference in syntax in PostgreSQL, Oracle, MySQL and MSSQL.
I will also explain the process SQL follows to execute recursive sql query. Then we shall solve 3 different SQL queries using recursion. I will execute the queries in all the major RDBMS such as PostgreSQL, Oracle, MySQL and Microsoft SQL Server.
My recommended platform to practice SQL queries: www.stratascra...
My recommended platform for SQL Course: learnsql.com/?...
Consider SUBSCRIBING to my channel if you wish to learn SQL, Python and Data Analytics concepts.
FTC disclaimer: This video was sponsored by Brilliant.
🔴 WATCH MORE VIDEOS HERE 👇
✅ SQL Tutorial - Basic concepts:
• SQL Tutorial - Basic c...
✅ SQL Tutorial - Intermediate concepts:
• SQL Tutorial - Interme...
✅ SQL Tutorial - Advance concepts:
• SQL Tutorial - Advance...
✅ Practice Solving Basic SQL Queries:
• Practice Solving BASIC...
✅ Practice Solving Intermediate SQL Queries:
• Practice Solving INTER...
✅ Practice Solving Complex SQL Queries:
• Practice Solving COMPL...
✅ Data Analytics Career guidance:
• Data Analytics career ...
✅ SQL Course, SQL Training Platform Recommendations:
• SQL Course / Training
✅ Python Tutorial:
• Python Tutorial
THANK YOU,
Thoufiq

Опубликовано:

26 сен 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 316

@techTFQ 2 года назад

Visit brilliant.org/techTFQ/ to get started learning STEM for free, and the first 200 people will get 20% off their annual premium subscription.

@singavarapunavya9143 2 года назад

Hi @techTFQ I have been following you since very long time and I got better in SQL just because of you! Thanks a lot. Now I have a problem and not able to solve it since 2 days! Could you please help me with it! SELECT * FROM YourTable WHERE '123' IN ('Col1', 'Col2','Col3'...'Coln') But the Where condition isn't working for 2 values example: WHERE ('123', '456') IN ('Col1', 'Col2','Col3'...'Coln') , Is there any way to search for 2 or more values existing in different columns??

@techTFQ 2 года назад

Thank you Navya .. You can use OR clause for this case.. WHERE ( Col1 in (123, 456) OR Col2 in (123, 456) OR Col3 in (123, 456) OR Col4 in (123, 456) )

@singavarapunavya9143 2 года назад

@@techTFQ Thanks for the response, Yes I did use it but I don't want to write multiple OR's because 123, 456 is not constant and these might go upto 100 or 200, so I have to paste them in every single OR condition every time! So is there any way to solve this issue? I want to give the values only once and it should check in all the columns for it's existence.

@techTFQ 2 года назад

Can you share the entire query and datasets with me so I can check . U can email me

@singavarapunavya9143 2 года назад

@@techTFQ sure thanks.

@correialc 2 года назад

Hi Thoufiq. I've been working with SQL (and teaching) for more than 2 decades and never found someone addressing SQL problems like you. The strongest aspects are problem-solving orientation (instead of theoretical) and ANSI standard queries (as much as possible). Congratulations! I'm recommending your videos to my students and workmates.

@techTFQ 2 года назад

Hi Leandro, Thank you so much 🙏🏼 It’s very special to receive such amazing feedback from an experienced SQL professional like yourself. Thank you for sharing this feedback, means a lot 🙏🏼 And thank you too for recommending my contents..

@sspinjari7643 2 года назад

Every single person who is working in SQL must have this channel in youtube subscribe list. I have recommended this channel to 3 colleague's & I am extremely happy to say they all liked this channel. And all 3 are thanking me 😍

@karthikeyanpandian1330 2 года назад

Hey Thoufiq, I have become a big fan of your content off late. I think that I have subscribed and started watching your videos for a month or 2. However, I have completed watching every single video that you have uploaded so far. The way of teaching is excellent and the examples that you provide are the backbone for the concepts that you are explaining. Great work! Thanks for the amazing knowledge share!

@techTFQ 2 года назад

Thank you so very much Karthikeyan :) I am so glad you have liked my contents. Thanks for the feedback too

@claybyfrancisshop Год назад

I've started my data science course and I thought that recursive cte wasn't meant for me but thanks to you i'm finally able to understand the logic behind it. Thanks Thoufiq.

@techTFQ Год назад

Thanks, glad it helped

@DinoDunelm 6 месяцев назад

Thank you so much for the detailed tutorial! I’ve been a data analyst for three years but never came across this technique until I received an interview from another company. Hope I can ace that SQL interview🤞

@mike-w1t2e 8 месяцев назад

I've looked at dozens of RECURSIVE CTE tutorials but until this one, I couldn't find an explanation of the JOIN condition. Thank you ... exactly what I needed!

@MimmoCRISTOFARO 6 месяцев назад

At last a clear, detailed and impressive explanation with real examples of what is, how it works and how to write a WITH RECURSIVE CTE. BRAVO!!!

@sachinvishwakarma5868 Год назад

Very well explained. I remember using the same concept when I had to generate the Voucher Code for one promotion feature. The voucher code should be AlphaNumeric and it should not already be present in the existing VoucherCodes table. It was very interesting and this concept had helped a lot.

@dhirendratripathi891 2 года назад

Literally I would say god level explanation, I was struggling with recursive query recently i had use case 👍

@santoshgowda7462 2 года назад

I have watched so many videos regarding the same topic but really you made me understand very easily...thank you very much. keep teaching us.

@techTFQ 2 года назад

Glad to hear that Santhosh ☺️

@SoumyaPriyaGodera Год назад

Hi Thoufiq,I am a beginner learning Data Science course. Your teaching skills are very good and anyone can understand the way you explain. I really thank you for the SQL videos which are very useful and also I recommend to my friends to watch your videos.

@theshanerap Год назад

You’ve taught me more in one week, than I learnt in one semester. GOAT STUFF!

@sujaa1000 8 месяцев назад

Hi @techTFQ, I wanted to express my sincere gratitude for the invaluable knowledge I've gained through your videos. As an experienced data engineer, I have found your content to be exceptionally insightful and well-presented. Your selfless efforts and dedication to teaching have not gone unnoticed, and I truly appreciate the time you invest in sharing your expertise. The clarity with which you explain complex concepts and the practical insights you provide on data analysis have been immensely beneficial to my learning journey. Your commitment to excellence in education is evident, and I wanted to take a moment to acknowledge and thank you for the positive impact you've had on my understanding of the subject. I have enthusiastically recommended your channel to many of my colleagues who, like me, greatly appreciate the quality of your content. Please continue your outstanding work, as it is making a significant difference in the learning experiences of individuals in the data engineering community. Thank you once again for your dedication and exceptional teaching. Regards

@cbarlow3 Год назад

Excellent explanation, Thofique! I like how when you ran the second example in multiple DBMSs, you went in an order that made you do an ever-increasing number of changes. :) I'll add another layer: if you were using Db2, you would have to 1. remove the RECURSIVE keywork, 2. use UNION ALL instead of UNION (I generally discourage using UNION by itself anyway), 3. specify column aliases as part of your CTE syntax (so far all the same changes you need for Oracle)...AND you also can't do an INNER JOIN in your recursive CTE! Not a problem for Example 1 (output integers 1 through 10), but for Example 2 it means you would have to go back in time to a time before INNER JOIN was invented (pre-1992!) and change your (INNER) JOIN to a Cartesian join (using the old-school comma-separated list of tablenames...not even the CROSS JOIN syntax!) followed by the appropriate WHERE clause to ensure you only get back the same rows that you would have with an INNER JOIN. Weird, right?

@dmitrii4799 2 года назад

Great explanation. How to show the hierarchy up and additionally if a manager has another employee, besides the searched one, show him and hierarchy down, if searching down found employee has 2nd manager then show him too. So we show all hierarchy of the company.

@shahid9813 2 года назад

Fantastic in my 10 years of IT i have not seen this in-depth tutorial. Amazing ✋

@timothymalahy7880 2 года назад

Definitely one of the better examples and succinct explanations. I liked how you reviewed the syntax first and came back to it when implementing. Keep it up.

@sql8758 2 года назад

Thank you so much for the video Taufiq. When I'm struggling to SQL problems, your videos are my first to go.

@techTFQ 2 года назад

I am glad to hear that bro

@anushas1910 3 месяца назад

Your Amazing sir . Even a person with Zero Sql knowledge can easily understand the concept .Thank you for your efforts to make us to understand the concept :-)

@Anonymous_it_is Год назад

You explain complex topics in a very intuitive manner. Awesome content!! I was having a hard time understanding recursive CTEs, but after watching this - everything seems crystal clear about recursive CTEs :)

@tuandino6990 2 года назад

Finally a video that can help me understand recursive sql query. Salute to you sir

@techTFQ 2 года назад

Glad this helped

@towhidulrazu 3 месяца назад

Your SQL videos are awesome & extraordinarily understoodable. Seems like taking a delicious chocolate everytime. Once again another SQL (recursive this time) is now clear like distilled water! Hats off bro!

@sonalilagnajita8740 Год назад

Hey @techTFQ, i have been struggling with recursive query from long time. You gave me a crystal clear understanding. Thanks

@linear_regression9541 2 года назад

Man, you are simply brilliant! You were able to make me to understand this (I couldn't even do that at university lol). I just have one suggestion: could you explain not so fast? Thank you so much bro! Greetings from Paraguay!

@techTFQ 2 года назад

Your welcome buddy.. Glad you liked it and noted on the suggestion 👍

@fenggao3170 Год назад

This is definitely an amazing lesson helping me to resolve the issues in my work. Thanks Thoufiq, you are an amazing tutor.

@siddheshaddarkar4074 4 месяца назад

Thanks a lot... CTE is great...we can further optimise by creating cte_employee to store employees _details in single time...and use the same cte in recursive

@Momo-qr3rd 2 года назад

Thank you very much🙏😊 It helped me a lot. Watching only one tutorial, made me follow and watch all of your videos. It is a great way to explain complex topics like this with examples. Could you please share your database for each of your tutorials so can pactise with it? Of course I could create it myself but its easier if you would share it.

@techTFQ 2 года назад

Thank you bro .. glad you liked it.. As for dataset, I always share it either in my blog or in my discord. For this video, you can get it from my discord

@sravangoud9700 2 года назад

@techTFQ 2 года назад

Thank you bro

@krishna6296 2 года назад

Awesome! Thank you and keep posting more SQL tutorials.

@techTFQ 2 года назад

Your welcome buddy and will do

@hiajayy 2 года назад

Please make videos on procedures and functions. Btw you are doing fabulous job.♥️

@techTFQ 2 года назад

Thank you Ajay and sure will do

@kinjalbrahmbhatt6410 5 месяцев назад

Hi toufiq, i have been go through many sql videos but your videos are very descriptive i love the way you elaborate small small details while solving queries,it would be great if you help out what is going on in industrial work Love from india

@Ismail-hd4yz 5 месяцев назад

Omg i was planning how to manage categories with multi level , and this will perfectly work for me. And most importantly i would able to all parents category and when user click on any of that i can get all which belongs to that specific category. My problem solved

@SwethaNandyala-sf9lt Год назад

Cant thank you enough for your content and explaination....lots of admiration from banaglore

@zhipengliu4767 5 месяцев назад

Thank you! This tutorial helped me understand recursive sql statement. Thanks very much!

@Rockythepom Год назад

A detailed explanation of confusing recursive query. simply Awsome

@a-ezzat5677 7 месяцев назад

i really respect you so much you are a professional in my opinion i have learned a lot from you . greetings from egypt

@shafi123 2 года назад

Thanks Thoufiq for precise and clear explanation

@techTFQ 2 года назад

Glad this helped Shaik :)

@prajwalsiwakoti9866 2 года назад

Thank u so much . Could you please make a video on database indexing in detail like what is it, how to do indexing and its usage? Thank you in advance

@techTFQ 2 года назад

Sure Prajwal , will consider doing it

@rohankhanna8006 2 года назад

Love the way you explained. Very easy to understand

@techTFQ 2 года назад

Thank you Rohan 🙏🏼

@hadibq 2 года назад

Brilliant Thoufiq! great way of putting things! TY!

@techTFQ 2 года назад

Glad you enjoyed it Hadi

@muthumariponmurugan7187 2 года назад

Hi Thoufiq, Thanks for your great job. I got a clear understanding of how to analyze a problem and its implementation. Looking forward to more such videos.Thank you

@techTFQ 2 года назад

Glad it helped MuthuMari

@Paragkini 2 года назад

Excellent info... Have always been thinking of handling it through code. Thanks bro.

@techTFQ 2 года назад

Glad this helped Parag :)

@odelolatechup1447 2 года назад

You are great I must be plain...more grace to your elbow... I am your big fan 🤗

@techTFQ 2 года назад

Thank you so much bro 😀 Appreciate your support

@faizanwar_ Год назад

Thoufiq Sir , you are best in the business for sure

@techTFQ Год назад

thanks buddy

@sreejitchakraborty6575 2 года назад

Beautiful explanation. The way you explain concepts is crystal clear. Thanks for the amazing videos.

@techTFQ 2 года назад

Thank you so much ☺️

@pradyumnamohapatra2448 Год назад

so clearly explained Taufiq...your videos really do magic...thank you so much and keep posting such learning videos

@puneetaggarwal7549 Год назад

Looking at your queries and way of explanation I wonder why I wasted my money on some SQL course. God why didn't I find your playlist earlier.

@vamsykamal8932 2 года назад

Ethical Vlogging !! kudos. Disclosing sponsorships @ very beginning. Hard to find such practice these days.

@gaberuth9274 2 года назад

Fantastic Tutorial. Thank you for actually explaining what the code is doing!

@LiveNobin 2 года назад

Hi Thoufiq, Thank you for this video.

@techTFQ 2 года назад

Your welcome buddy

@johnsaleem470 Год назад

Thank you Tafiq for such a wonderful job. You are an excellent teacher, and I have learned SQL from your channel. Keep it up, and be good.

@lambdaboss5528 2 года назад

Another awesome video. Very well explained and easy to understand. Thanks.

@techTFQ 2 года назад

Thank you so much ☺️

@ashutoshbafna6617 2 года назад

thank you. you explained beautifully. please give some examples to practice apart from what you have solved - to check learning on these concepts, if possible. thanks a lot .

@techTFQ 2 года назад

Thank you Ashutosh :) will consider you request.

@kaiyao5135 2 года назад

Thanks so much! very clear and details, love your tutorials!

@techTFQ 2 года назад

Thank you :)

@suyash7450 Год назад

Watching your videos makes me Believe that Learning SQL is not that difficult as it seems when we learn from an online course or any other portal, your way of explaining concepts both theoretical and practical is very simple and even a beginner can learn with ease. keep doing the great work.

@deepapanneerselvam4618 Год назад

Mind blowing explanation ..awesome😍😍😍.. Wonderful lectures .. I admired the way to explain the each and evry concepts from scratch to advancced level.

@kosmipologe Год назад

Awesome video, very well explained. Thank you. Just one little thing with the last example. I wished you would have changed the level number backwards somehow.

@ririraman7 2 года назад

Make a video on CROSSTAB in postgresql...or pivot in sql

@techTFQ 2 года назад

Sure will do

@ririraman7 2 года назад

@@techTFQ Thank you veere. You came as angel in our lives. SQL💪

@tyl9680 2 года назад

Which method is more efficient? (1) Recursive or (2) declare a temp table and use while loop to add the result to the temp table?

@nisha6165 2 года назад

Hi, pls try to post complete vedio on stored procedures and thanks for this vedio

@techTFQ 2 года назад

Sure Nisha will do it soon

@nisha6165 2 года назад

@@techTFQ Thanks you🙂

@vijaykumar-sy3uu Год назад

Thanks a Lot Thoufiq for Making great content😀 .Request:: Please make video on UDF

@cgittoes 8 месяцев назад

Great video. Helped made a complex topic easy to understand and follow

@kokarao4874 2 месяца назад

Very detail explanation

@yash1152 Месяц назад

25:39 add "H.name" in select clause in line 7

@callravik 2 года назад

Let us see 1st problem. For the 1st iteration, we know there is 1 row , so for the 2nd iteration, it would be n + 1 = 1 + 1 = 2. Now for the 3rd iteration, we have row 1 and row 2, would n + 1 operates only on the latest row which is 2, and ignores the 1st row? Or else for each execution all the rows would be incremented by 1 which is wrong.

@raghud541 2 года назад

Thanks a lot for this wonderful explanation.

@techTFQ 2 года назад

Your welcome 🙏🏼

@sangnguyet2011 7 месяцев назад

Thanks!

@QelDoQ Год назад

Thank you! This explained things so clearly.

@shaikhanuman8012 Год назад

Tq for sharing valuable information, sir.

@jaewonyang Год назад

Excellent explanation! Thank you very much.

@jaydeeppatidar4189 2 года назад

Very well explained! Thank you!

@techTFQ 2 года назад

Glad it was helpful!

@alanmiles6680 Год назад

Usually, great tutorials from him. However, for this particular tutorial, I had to Google, "What is a recursive query?" in the first place.

@gouravburnwal4883 2 года назад

Great video on Recusive functions in sql. please make a video on views and indexing.

@techTFQ 2 года назад

Thank you Gourav 🙏🏼 I have already made a video on VIEWS.. as for index, will do it in the near future

@ckarkhan 7 месяцев назад

Hi Tofiq...once again you'e. knocked it out of the park! One question on window frames. In some databases, RANGE is not supported at all. Just ROWS is supported. How can we equate the behavior of ROWS to the same as RANGE? Best Regards!

@ytef9398 Год назад

Wooah.. you deserve many subscription. Many thanks, you save my week.. One question, is this work well for a big data row, or better using another method?

@sambacarlson 7 дней назад

Thanks man. really useful.

@kancharalaparameshwarreddy3837 2 года назад

excellent video sir

@techTFQ 2 года назад

Many many thanks bro

@foryoutube2563 8 дней назад

Thanks

@ambikabahuguna7908 2 года назад

great explanation

@techTFQ 2 года назад

Thank you :)

@vasireddyvishnu8012 2 года назад

Your videos are great . Please do videos on pl/sql also

@techTFQ 2 года назад

Thank you bro and sure will do

@majidnabavi9900 Год назад

Best explanation , thank you ;)

@purvamargaj5480 2 года назад

Please do one video on Microsoft SQL Server

@techTFQ 2 года назад

this is applicable to Microsoft SQL Server also.

@cooldwnload 2 года назад

Great work to bring in all concepts 👍

@techTFQ 2 года назад

Thanks a lot 😊

@maximilianjaeger8545 Год назад

10 out of 10 Video🤝

@davidhickman4976 2 года назад

Very useful video. Thank you!

@techTFQ 2 года назад

Glad it helped

@jullienbeaufondcamacho2055 10 месяцев назад

Superb explanation! 👏

@techTFQ 9 месяцев назад

Thank you 🙂

@satheeshkumarak6708 2 года назад

Such a Masterpiece!!!

@techTFQ 2 года назад

Thank you bro

@ismailrana Год назад

Excellent, I really love your all videos.

@vikassrivastava7081 2 года назад

Hi sir , Can we expect a comprehensive tutorial on oracle sql and plsql In near future? Big fan of ur way of explaining these concepts 👍

@techTFQ 2 года назад

generally I do not want to make a video specific to any RDBMS. Since SQL is an ANSI standard, I prefer to cover SQL concepts which can be applicable to any RDBMS. With this in mind, I may do a complete SQL tutorial in the future. For now, I will be conducting LIVE SQL Course from beginning to advance level starting next month on Lighthall. Will announce it soon on RU-vid and LinkedIn

@techTFQ 2 года назад

You can find the link in my channel about section

@shradarai1068 Год назад

sir i didn't get the purpose of 'union' and 'lvl' functions here, could you please make a video on these two things.

@jerilcj9586 Год назад

well explained something complex. Thanks

@ayanSaha13291 2 года назад

You are fantastic! Thanks a lot.

@techTFQ 2 года назад

Thank you Ayan

@shahzadqasir5122 Год назад

Thanks for the Video Tutorial

@kumarbabu1274 Год назад

Nice video ..really appreciate..can you please suggest aany place where I can solve and learn advanced SQL queries

@spandanalakkakula6706 2 года назад

Good work.. Thank you for all the videos you upload. Can you make a video on the "find interview candidates leetcode (1811)" problem.

@techTFQ 2 года назад

Noted, will consider it

@AlexanderPoznanski Год назад

Thank you! Interesting!

@indrajithserasinghe6766 2 года назад

really good and very good explanation

@techTFQ 2 года назад

Thank you 🙏🏼

@ArghyaDas793 11 месяцев назад

Hi Thoufiq, what if the ask is to show only the immediate sub-ordinates of Asha?

@shankerm3959 Год назад

Well explained and i find it useful. Thank you.

@aakriti_100 2 года назад

I did both these topics (CTE & recursive CTE) from LinkedIn learning; they made me feel like I can't learn but you make SQL so easy. Thanks for your content:-) I'm at my first step as data analyst; looking forward to have help from you.

@techTFQ 2 года назад

I am glad to hear that Aakriti