I have never seen anyone explain this so clearly. Thank you so much
@osoriomatucurane95118 ай бұрын
You are absolutely right, I must admit
@TDMac112 ай бұрын
I've been trying to understand this for 24 hours with no real traction and you summed it up in 10 minutes. You have a real gift, thank you.
@maxwellbicking8276 Жыл бұрын
Please do an advanced SQL course as a follow up to your Ultimate Bootcamp! It would be so awesome to see more advanced applications of SQL for data analytics
@johnvak73906 ай бұрын
Bro literally the clearest of explanation and a guy that actually explain all the parts. If i ever get into data analytics, i hope i have someone like you as a person I can shadow. STG
@joshuaagama1014 Жыл бұрын
I am so grateful. This explanation erased every confusion!
@subhambasu40123 күн бұрын
Best ever video that I saw over any platform regarding SQL window functions.....
@janardhan4814 Жыл бұрын
I have always been trying to use the window functions without understanding how they work. Thanks to you, most of the window functions now makes sense.
@topanime756310 ай бұрын
Short, direct and clear explanation. You dropped your crown 👑
@banamailat_BM Жыл бұрын
Really thank you. I'm pretty new to SQL. All the puzzle pieces related to Window functions fell into place. I didn't fully understand until I watched this video. Thank you again.
@proterotype5 ай бұрын
Dude, I am nerding out over this! Where has this been all my life
@kelsey.ann.taylor Жыл бұрын
WILDLY helpful, this is the first video I’ve found that lays this out so clearly. Wish I’d found this before the technical interview I had today 😂😅
@HL-SBR8 ай бұрын
You're heaven sent. Been racking my brains since last month learning SQL on a browser based coding tutorial site, and some concepts are just plain jargon for me. You're explanation here is super simple and easy to digest. I guess some people really have that talent on how to teach superbly well. Great job, I think I'm gonna sign up on your Udemy SQL course enhance what I already learned.
@vybhavavenkatesh77035 ай бұрын
I like the last sentence in the video. great explanation.
@sargata30542 күн бұрын
Awesome explanation and demonstration. I finally understand OVER() more. Thank you!
@Ira-rr7lfАй бұрын
It's the best explanation of the Window Functions that I've seen. Thank you so much!
@jingchaowang55323 ай бұрын
The best lecture on window functions EVER. Thanks Colt!
@theamithsingh5 ай бұрын
glad i clicked this as my first video about window function 😊
@muhammadarshadalishaik6870Ай бұрын
Within 10 minutes, I got what I needed. Excellent presentation. Wish you made videos on advanced SQL like cte...
@monicabetancourt79966 ай бұрын
Wow you made something so hard and complicated to explain to a walk in the park. Thank you! I am new to this, and it was in Martian; now it is in simple English. Blessings!
@carlosfernandez6477 Жыл бұрын
Literally the best explanation so far
@limotto945224 күн бұрын
Thank you very much for making this video. I have a hard time to fully grasp the concept of window function. Your explanation clears all confusion for me and I will rmb this forever.
@littlebigdawg Жыл бұрын
I spent over an hour not understanding this until now. Thank you!
@SistaSueK24 күн бұрын
You are a very talented teacher.
@sidmoitra00710 ай бұрын
Hi, I have bought ur course in udemy. Thanks for all your effort. Great teacher!
@thiorofall8751 Жыл бұрын
So far, the best SQL Window functions video. Thanks you so much!
@evelyn_deforest936 ай бұрын
I really struggled with window functions and thanks to you dude I think it's finally starting to make sense!
@marcelobour Жыл бұрын
Super clear explanation, in 2 minutes I had understood, thanks!
@Our_Joyful_Journeys3 ай бұрын
You are the best!. clearly explained the Window functions
@muradaslanli88749 ай бұрын
Great thanks for amazing and understandable explanation. Even I have watch many youtube videos, however only understand it after your video. Thank you, keep going👍
@siddharthsingh503110 ай бұрын
Wow! This was gold standard explanation. Thanks a lot.
@xgerra165 ай бұрын
WE NEED THAT ADVANCED SQL COURSE KING!!
@dominicirudhayaraj13132 ай бұрын
Wonderful crisp and clear
@andrecoetzer7032 Жыл бұрын
Colt you should become a model. You a natural infront of the camera xD. I have a feeling you enjoy the picture taking a lot. Haha
@olgaklimenko9443 ай бұрын
The most understandable explanation about window functions ever
@emilymalkin2703 ай бұрын
I stumbled upon this lesson by chance and I am amazed by your teaching style and presеntation! I actually know about all that was taught in this lesson, but I just could not stop watching because oh how well you presented! I wish you taught Power BI because I was looking for a power BI equivalent. 😉
@austecon68183 ай бұрын
So great. Thanks. I wish you would have also covered cumulative sums though too because I am using that now.
@emanuelgabrielbarata41215 ай бұрын
the best explanation on window functions I`ve ever seen, thanks
@shadowthehedgehog27278 ай бұрын
Damn SQL is so powerful... great job explaining this
@ekaterinaafanaseva64602 ай бұрын
The clearest explanation ❤
@tonywalls17284 ай бұрын
Instant sub! Didn't even have to rewatch, this was SO clear. Thank you so much!!
@perianka5 ай бұрын
THIS WAS SO CLEAR TYSM
@pablovindas99556 ай бұрын
A simple clear explanation, finally I got it! Thanks
@edgarleiva21446 ай бұрын
Best explanation of the world!!!, so happy that I could dance with a wheelchair
@returnMarcco4 ай бұрын
Great lecture, clear and concise 👍
@katyaynisrivastava99617 ай бұрын
I don't usually write comments, I'm sleepy and my brain is working in 2 cells but I still got it. Great explanation.
@carloslizarraga12404 ай бұрын
Such a great video to understand this advaced concept. Thanks a bunch!!
@fdu65 ай бұрын
This was absolutely perfectly clear. Thanks for your work
@bbiasao25 күн бұрын
Very clear explanation! Thanks!
@pratikmandlecha66727 ай бұрын
Perfectly explained. Thanks
@GabrielGarcia-ew2em Жыл бұрын
It was sooooo clear, AMAZING explanation, thank you very much man!
@religious215515 күн бұрын
Nice , Easy explanation thank you
@mohamedfaalil Жыл бұрын
this video is gem.
@chandanjha32056 ай бұрын
Best video on this topic...
@aditideshpande55663 ай бұрын
Great video! Thanks for explaining this so clearly!
@claraoliva25410 ай бұрын
lifesaver omg thank you so much for the side by side comparison of group by vs window
@rohitpatil61117 ай бұрын
so easily and seamlessly explained. thank you so much
@VinayBora-eq9igАй бұрын
wow! very nice tutorial🤩
@michaelp90615 ай бұрын
One of the best on this topic. Thank you.
@jouGOETE4 ай бұрын
Well explained in an English accent I can understand. Thank you... (English isn't my first language, b.t.w.)
@yanivavraham37727 ай бұрын
VERY GOOD EXPLANATION THANK YOU!
@qamarhoms588010 ай бұрын
Very clear explanation thank you
@sakshamp4488 Жыл бұрын
bro loved your content as always ,i have oa next week ,wish me luck!
@user-og9fr7ct2u4 ай бұрын
This was brilliant, thank you so much!
@goramnikitha54918 ай бұрын
Love the explanation
@anjumanalam Жыл бұрын
Woohoo! Glad to see you doing SQL
@mrmuranga4 ай бұрын
well explained thanks Colt...
@user-ek4rp7fi9l6 ай бұрын
very clear explanation
@mohammadturabali387010 ай бұрын
Excelletnt and to the point explanation
@vaibhavsrivastava95855 ай бұрын
Very well explained
@inkarsagatova3733 ай бұрын
Thank you! You really helped so much
@Joeysz Жыл бұрын
We need an advanced SQL course!
@ilkhomjoon27 күн бұрын
very nice explanation.
@user-ve3no9pm9wАй бұрын
this video is fantastic, thanks a lot
@markslima1557 Жыл бұрын
Oh awesome! Thanks for posting a video on this totally was looking for more info on SQL window functions.
@imtiazshoykat3 ай бұрын
Thanks. This is so helpful though I still only know oracle Sql 😊
@hameddadgour4 ай бұрын
Great video. Thank you for sharing!
@djalan842 ай бұрын
Nice and clear!!
@valentinakurenshchikova81186 ай бұрын
great explanation !
@arkyadas784914 күн бұрын
Please make a video explaining how running total gets calculated with window function. I mean what is the inner working.
@Qasimwahaj202411 ай бұрын
Thank you for making it easy to understand.
@fbravoc97489 ай бұрын
Amazing window function explaination!! Thanks!
@SuaveBBX7 ай бұрын
Thanks champ! You are the best!!
@pranavbhat928 ай бұрын
Very clear! Thank you Colt
@marcc1179Ай бұрын
great job!
@adrianoschwenkberg67734 ай бұрын
very useful, thanx for the efforts
@fangnick417120 күн бұрын
Crystal clear
@sharmanihal997 ай бұрын
Great video
@JamesTAu9810 ай бұрын
That was awesome. Thanks
@mov_ax_200h11 күн бұрын
You're a genious!
@ahmadkelany11 ай бұрын
Thanks, clear and concise explanation 👌 Just perfect.
@siddarth17082 ай бұрын
Very helpful. Thanks a bunch!!!!
@kyang-cj2ik8 ай бұрын
Thank you so much. It was helpful!
@TheViktormartin2 ай бұрын
Nice video!
@mihailisman89409 ай бұрын
Very good explanation. Thank you!
@nehashinde60177 ай бұрын
thank you!!!!!!!!!
@zynga512 Жыл бұрын
Very solid explanation, Thanks mate
@user-xo3wj5fe2m9 ай бұрын
Very well explained. Thank you!
@raghavendrac4710Ай бұрын
Very helpful!
@DIKSHITKUMAR7 ай бұрын
in the rank without partition, it misses the rank for a Tied row, at 7:22 if you see it shows rank 1 to 6 and than 7 7 9 ... and so on. This misses rank no 8 due to two 7s rank. How do you get rank for all without omitting any rank? Please any one guide me