Thank you Ashuthosh..after following your advance sql videos now I feel that I choose right path of learning , also gaining confidence to face interviews.
Hi Ashutosh, thank you for this video. I have one more question and request for you, something I wanted to see in implementation. Can you please create a video on Key/Value Pair Join for look up tables, especially emphasizing on Joins (Left, Inner, Self etc). This will be really helpful.
Hi, Can someone please tell me why this code is giving a different output than what Ashutosh has used for question 3- Alternate cab for customers, though I have used the same logic- select a.name,a.from_state,b.id,b.charge from customers a,cab b,order_1 c where a.min_seater
👉 SQL Portfolio Project Indian Census- Part 1
th-cam.com/video/I3YvjFfn478/w-d-xo.html
👉 Advanced Sql Concepts Complete Playlist
th-cam.com/play/PLbTF1OfX62c3RQ_ZFfyNBWVPdz_OWTMLG.html
Thank you Ashuthosh..after following your advance sql videos now I feel that I choose right path of learning , also gaining confidence to face interviews.
Thanks
In answer to last problem can we not use filter condition for date- order date>='03-07-2022'
Exalant
Hi Ashutosh, thank you for this video. I have one more question and request for you, something I wanted to see in implementation. Can you please create a video on Key/Value Pair Join for look up tables, especially emphasizing on Joins (Left, Inner, Self etc). This will be really helpful.
cn you share the problem example - ashutoskr103@gmail.com
Hi, Can someone please tell me why this code is giving a different output than what Ashutosh has used for question 3- Alternate cab for customers, though I have used the same logic-
select a.name,a.from_state,b.id,b.charge from customers a,cab b,order_1 c where a.min_seater
Can you upload frequently asked questions in sql?
yes sure
Self join like a brain teaser
Yes
These problems are now days solved through AI
It's of no use in the near future.
Oh ok great thanks ,Which algorithm can be used for this scenario, may I know ?