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

Amazing! Thank You!

nice

This video helped me a lot, Thanks !

SUPPERB VIDEO


create table sales (
product_id int,
period_start date,
period_end date,
average_daily_sales int
);

insert into sales values(1,'2019-01-25','2019-02-28',100),(2,'2018-12-01','2020-01-01',10),(3,'2019-12-01','2020-01-31',1);


select period_start, period_end, datediff(period_end, period_start) as diff from sales;

with recursive cte as (
select period_start as start, period_end as end,
product_id, average_daily_sales
from sales
UNION ALL
select DATE_ADD(start, INTERVAL 1 DAY), end, product_id, average_daily_sales from cte
where DATEDIFF(end, start) > 0
)

select YEAR(start), product_id, count(*), sum(average_daily_sales) from cte
group by YEAR(start), product_id
order by product_id, YEAR(start);

To learn this concept more precisely

Superb explanation! 👏

Hi Taufiq Sir , Very informative Video , sir please one request i have mac mini m2 i want to install Oracle DB please guide 🙏🙏

Is nestled recursive query feasible in SQL?

Hi Thoufiq pls make a tutorial on Ceil, floor, Absolute value & while loop for SQL if it is possible for you..

Thank you so much!

Hi techTFQ make a tutorial on user-defined functions

Can any one help me to find 1 to 50 numbers using recursion and also specifying numbers as even and odd.❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤

so in mysql recursive is just a regular 'with clause'?

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

At which point in second question join condition will fail? please help me to understand this

kidhar se ho bhai aap

Brilliant Tutorial

What is the error if only asha shows?

Thank you!

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 :)

Sir one on cursor implementation

Very good job man

Tq for sharing valuable information, sir.

Wow

could you please tell
what is the difference between connect by clause and recursive ..same series or hierarchy data we can also print using connect by clause

thank you some much!!!!!!!

Hi Thoufiq.
I have a question on using recursive CTE on multiple tables. Please advise where can I post that question. I would really appreciate your help. Thanks.

Your video was the best resource for learning recursive queries I came across on the internet so far !

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?

Why does SQL Server still show all the red squiggle lines under most of the query even though everything works? Thanks.

Excellent!

where can I get this database?

wonderful explanation.

I like your ears.

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.

A detailed explanation of confusing recursive query. simply Awsome

Excellent explanation! Thank you very much.

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

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

Thanks for the Video Tutorial

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.

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.

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

Thoufiq Sir , you are best in the business for sure

You seems make it so easy but it really not unless you can solve some of your own

Best explanation , thank you ;)

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

Looks AS COOL AS CUCUMBER

Thank you! Interesting!

Thank you! This explained things so clearly.