Ankit , this is the top class things of Analystics , kindly share more videos like this where we get to know more real world problems; KPI metrices etc !
Bhaiya only adha samajh me aaya baaki isiliye nhi aaya qki mere concept clear nhi h . Soon I'll join your course. But I can say it's very advanced and important for a successful data analyst Thanks a lot
Hi Ankit, Thank you very much for your content. You explain in simple layman terms and understandable way. I am facing a problem in finding the difference between two dates in hours excluding the weekend hours. Can you please make a video on this.This should cover all scenarios like first date and second date on weekdays and firstdate, seconddate on weekends, firstdate on weekday and 2nd date on weekend and firstdate on weekend and second date on weekday. I hope you understood the requirement. Giving one example for this requirement. date1 = 2024-02-24 21:00:00 and date2 = 2024-02-26 04:00:00 and the difference should give 4 hours as 2024-02-24 and 2024-02-25 are weekends and hours should be considered only for 2024-02-26 which is a weekday. Solution should cover all scenarios. Thanks!!
Respected Ankit Sir, Best video for learning new things, Sir will you please share query I write query but i forgot what is the next step. And my concern is that i want to calculate for financial year which is starting from 1st April and ends on 31st march so please sir help me. First quarter is April to June then second then third and final last is january to march. Sir, I am poor in my english communication skills but trying my best for learning new things so please help me
Awesome video sir...i have 9 yrs exp in Oracle database developer so to boost the profile which other tool or technology should be learn? Or sq/ plsql is enough?
Please do like the videos to increase its reach . Thank you in advance 🙏
it's same fiscal year
Ankit sir, please share the advanced SQL course link to buy. Hindi English both are fine
@chiranjib-konwar www.namastesql.com/course-detail/think-sql-go-from-zero-to-hero-english
@ankitbansal6 can u share whole query of time frame table please
@@anandmahajan943 in the description box
Ankit, Really you are the god of SQL. Please keep helping people like us 🙏
agreed!!! god of sql
never thought it was possible, once I saw the title of your video I was convinced it is possible. Keep up the great work
One word, tooooo good. How to handle all scenarios, you beautifully explained. Thanks
Glad you liked it
Ankit , this is the top class things of Analystics , kindly share more videos like this where we get to know more real world problems; KPI metrices etc !
wow superb never thought that it was possible
Thank you Ankit Bro
Bhaiya only adha samajh me aaya baaki isiliye nhi aaya qki mere concept clear nhi h .
Soon I'll join your course.
But I can say it's very advanced and important for a successful data analyst
Thanks a lot
Hi Ankit, Thank you very much for your content. You explain in simple layman terms and understandable way. I am facing a problem in finding the difference between two dates in hours excluding the weekend hours. Can you please make a video on this.This should cover all scenarios like first date and second date on weekdays and firstdate, seconddate on weekends, firstdate on weekday and 2nd date on weekend and firstdate on weekend and second date on weekday. I hope you understood the requirement. Giving one example for this requirement. date1 = 2024-02-24 21:00:00 and date2 = 2024-02-26 04:00:00 and the difference should give 4 hours as 2024-02-24 and 2024-02-25 are weekends and hours should be considered only for 2024-02-26 which is a weekday. Solution should cover all scenarios. Thanks!!
Your sql videos are fantastic. Its really helped improve my skills keep up the great work sir thanknyou so much❤❤
this video is top notch !! awesome work
Cheers 🥂
sir, you are true champion.
Simply Awesome!!
How awesome is that, thanks for the video.😀
Thanks for watching!
Hi Ankit
Please try to create videos on data modelling for any product
This is really good video 👍
Glad you think so!
Superb❤
Thank you sir for making this video
Awesome 😎
Thank you! Cheers!
Respected Ankit Sir,
Best video for learning new things,
Sir will you please share query I write query but i forgot what is the next step. And my concern is that i want to calculate for financial year which is starting from 1st April and ends on 31st march so please sir help me. First quarter is April to June then second then third and final last is january to march.
Sir, I am poor in my english communication skills but trying my best for learning new things so please help me
description box
When to start AWS training
My SQL GOD🙏
🙏
Awesome video. I am new subscriber to your channel. Could you please share the link for datasets used in your video and also queries.
In the description
Awesome video sir...i have 9 yrs exp in Oracle database developer so to boost the profile which other tool or technology should be learn?
Or sq/ plsql is enough?
Learn python
Thanks 😊🙏
Is calendar year table will refreshing automatically as per the time frame ? So we dont need hardcode anything
Exactly
Where is create and insert statement for practice?
description box
I want to buy course in advanced SQL. Please share the link to buy the advanced sql course.
Thanks 🙏
www.namastesql.com/courses/SQL-For-Analytics-6301f405e4b0238f71788354
Hello sir please share the query so that we can practice
in the description
Sir, please share query files please
where is the insert statement?
check description