Ankit Bhai, boht barhya kaam kiya hai... 2 months se dhoondh raha tha. Itnay din se yeh video kidhar th bhayya. Thanks ❤

So excited for the upcoming query questions related to this calendar dimension table.

Thanks for creating the data engineering videos, I love your explanation. Good luck sir

you blown my mind. god bless another god of sql.

Thank You Bro Super explanation. I am learning very good stuff from you

you are the man ... Always great content -:)

Very good Logic ❤❤❤

Thank you Ankit 🙏🏻

Thankyou it's really superb 👏👏

Nice explanation dates functions Ankit bhaiya ❤❤🎉🎉

Can you explain me what is the use of in joining of two table or in self join?

No more distraction.. Just stick to Ankit Bhansal YT channel for SQL & thanks me later 😅

Hi Ankit, it is a great learning, I have been following you from the beginning, would you please implement day light saving logic in the where condition, ex: my views delivering the report every 1 hour to the business

Hey Ankit are we considering leap year also in the calendar?

Perfect explanation

Hey Ankit, Can you please help me with how to create this dimension table in mysql I am done with all the script following your video but I got stuck at last point when we need to create the physical table. This query is not working in mysql....please help. SELECT row_number() over(order by cal_date asc) as id , * into calendar_dimension from cte ; SET SESSION cte_max_recursion_depth = 1000000; Thanks in advance

Please make a video on subquery. I am not able to understand how to solve subqueries problem. I tried a lot from different different resources but not able to solve it . And if there is any cheat method for this then also please share. Thankyou

I tried to make a calendar table in MySQL: SET cte_max_recursion_depth=30000; with recursive cte as (select cast('2000-01-01' as date) as cal_date ,year('2000-01-01') as cal_year ,dayofyear('2000-01-01') as cal_year_day ,quarter('2000-01-01') as cal_quarter ,month('2000-01-01') as cal_month ,monthname('2000-01-01') as cal_month_name ,day('2000-01-01') as cal_month_day ,week('2000-01-01') as cal_week ,weekday('2000-01-01') as cal_week_day ,dayname('2000-01-01') as cal_day_name union all select date_add(cal_date, interval 1 day) as cal_date, year(date_add(cal_date, interval 1 day)) as cal_year, dayofyear(date_add(cal_date, interval 1 day)) as cal_year_day, quarter(date_add(cal_date, interval 1 day)) as cal_quarter, month(date_add(cal_date, interval 1 day)) as cal_month, monthname(date_add(cal_date, interval 1 day)) as cal_month_name, day(date_add(cal_date, interval 1 day)) as cal_month_day, week(date_add(cal_date, interval 1 day)) as cal_week, weekday(date_add(cal_date, interval 1 day)) as cal_week_day, dayname(date_add(cal_date, interval 1 day)) as cal_day_name from cte where cal_date < cast('2050-12-31' as date) ) select row_number() over(order by cal_date asc) as rn, cal_date, cal_year, cal_year_day, cal_quarter, cal_month, cal_month_name, cal_month_day, cal_week, cal_week_day, cal_day_name from cte;