I study a lot from internet , you-tube but it happens very rare I comment on those videos. This video deserves appreciation. Such a great Channel. Hope you grow the ladders of success. Thank you for such a good explanation.
Bro.. I have a doubt...Can you please explain.. Please! How does this query work internally.. I mean Order of precedence : rank() over(partition by staidumname order by runs desc) (1) Partition by > Order by > rank() (2) Order by > partition by > rank()
@@AshutoshKumaryt I mean intro is good, but the sounds in the background don't sound good on the earphones. It can be a little soft. It's pretty harsh on the ears.
@@raunaksharma7890 yes you are right just heard for the first time with my earphones, thanks for bringing to my notice will be taking care of this in future 🙂
I study a lot from internet , you-tube but it happens very rare I comment on those videos. This video deserves appreciation. Such a great Channel. Hope you grow the ladders of success.
Thank you for such a good explanation.
👉 SQL Portfolio Project Indian Census- Part 1
ruclips.net/video/I3YvjFfn478/видео.html
👉 Advanced Sql Concepts Complete Playlist
ruclips.net/p/PLbTF1OfX62c3RQ_ZFfyNBWVPdz_OWTMLG
You should give the links of the dataset in the description box .
@@sauravlabade1366 i have give the link
github.com/ashutoshkr103/Microsoft-Excel-Tutorails/blob/main/Advancedsql.xlsx
bhai at 14:59 you do the zoom how it is done in editing or live how? explanation is quite practical to understand
excellent tutoring man....respect
Thanks
Why do we have to use rows between whenever we are using the last_value, even if we are using it as the only constrain
brother please watch previous video that is first_value, last_value and nth value video, you will more clarity
I want use sum runs with partition by stadium name but not partition by eden garden stadium how can I solve this?
Use where clause , where stadium name is not equal to Eden gardens
Bro.. I have a doubt...Can you please explain.. Please!
How does this query work internally.. I mean Order of precedence :
rank() over(partition by staidumname order by runs desc)
(1) Partition by > Order by > rank()
(2) Order by > partition by > rank()
I guess 1
u did good job
Great information ❤
unable to download any file from github
hey Rahul try logging in github then try once even then if face issue connect with me on insta @ashutosh.analytics
Thanks!
Thanks
Very helpful !
Thanks
The excel file is not downloadable
Try once more
github.com/ashutoshkr103/Microsoft-Excel-Tutorails/blob/main/Advancedsql.xlsx
Sudden intro music was a mini heart attack. Better not to put such annoying sounds in intro.
Sorry for that
My advice would be to change the sound effects, it's annoying.
Do you mean my intro ?
@@AshutoshKumaryt I mean intro is good, but the sounds in the background don't sound good on the earphones. It can be a little soft. It's pretty harsh on the ears.
@@raunaksharma7890 yes you are right just heard for the first time with my earphones, thanks for bringing to my notice will be taking care of this in future 🙂
@@AshutoshKumaryt Yeah man! Appreciate it.
@@AshutoshKumaryt mast hai bhai, maza aa gaya sound effects sunke, katai cinematic.
SIR AAPSE BAT KRNA HAI
I'm at 9 min still he hasn't explained
It is bcoz You cannot learn partition by in SQL within 9 mins
Please explain partion first
p1 is none other than virat kohli😆