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
I hardly ever comment on video but I had to for this video, I have been so confused about how to use these Window functions, this video is the most simplifed explanation. Thank you very much. After watching this video, I understand it perfectly well, no longer confused again
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
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.
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.
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.
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!
@colt steele, I bet you are loving the comments. Should I drop a negative one? I couldn't even if i tried cos this video is just so good, no devil can write anything negative about it. Absolutely the best sir. Whatever you are piping, keep piping it, cos that's some good stuff.
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👍
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
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. 😉
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.
I have never seen anyone explain this so clearly. Thank you so much
You are absolutely right, I must admit
thats true
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
I hardly ever comment on video but I had to for this video, I have been so confused about how to use these Window functions, this video is the most simplifed explanation. Thank you very much. After watching this video, I understand it perfectly well, no longer confused again
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.
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
Window functions best video I have come across. Thank you.
I am so grateful. This explanation erased every confusion!
Dude, I am nerding out over this! Where has this been all my life
Short, direct and clear explanation. You dropped your crown 👑
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.
After struggling for 2+ hrs, came here and you cleared it up in 10 mins. Thank you, thank you, thank you!!
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.
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 😂😅
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.
Bro has the clearest explanation even after 2 years. Thank you for the amazing tutorial.
This was an AMAZING video. Holy crap I was learning this in class and made no sense. This was exquisitely explained. Thank you.
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!
This is the best video on window funcitons i've ever watched. Thankyou for making the concept clear.😇
Hi, I have bought ur course in udemy. Thanks for all your effort. Great teacher!
glad i clicked this as my first video about window function 😊
I don't usually write comments, I'm sleepy and my brain is working in 2 cells but I still got it. Great explanation.
This explanation is everythingggg!! Thank you Colt.
Hey Mr. Colt, great explanation concise and clear. I'll keep following your work.
Cheers.
Best ever video that I saw over any platform regarding SQL window functions.....
Within 10 minutes, I got what I needed. Excellent presentation. Wish you made videos on advanced SQL like cte...
@colt steele, I bet you are loving the comments. Should I drop a negative one? I couldn't even if i tried cos this video is just so good, no devil can write anything negative about it. Absolutely the best sir. Whatever you are piping, keep piping it, cos that's some good stuff.
Best explanation of the world!!!, so happy that I could dance with a wheelchair
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👍
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
It's the best explanation of the Window Functions that I've seen. Thank you so much!
Wow! This was gold standard explanation. Thanks a lot.
Literally the best explanation so far
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. 😉
The best lecture on window functions EVER. Thanks Colt!
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.
thank you. I wrapped up what I needed to know with this video
Super clear explanation, in 2 minutes I had understood, thanks!
So far, the best SQL Window functions video. Thanks you so much!
This is TOP TIER explanation, thank you so much!
Great video - the explanation, the visuals you use,... Thank you!
the best explanation on window functions I`ve ever seen, thanks
I spent over an hour not understanding this until now. Thank you!
Awesome explanation and demonstration. I finally understand OVER() more. Thank you!
The most understandable explanation about window functions ever
A simple clear explanation, finally I got it! Thanks
I like the last sentence in the video. great explanation.
Dude. You're a lifesaver!
So great. Thanks. I wish you would have also covered cumulative sums though too because I am using that now.
Instant sub! Didn't even have to rewatch, this was SO clear. Thank you so much!!
This is a very clear explanation. Thank you!
This was absolutely perfectly clear. Thanks for your work
Amazing video. So much given in just 10 minutes. I'll definitely buy the Udemy course.
You are a very talented teacher.
Well explained in an English accent I can understand. Thank you...
(English isn't my first language, b.t.w.)
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
Great lecture, clear and concise 👍
lifesaver omg thank you so much for the side by side comparison of group by vs window
WE NEED THAT ADVANCED SQL COURSE KING!!
Dude this was so well explained, thanks man
It was sooooo clear, AMAZING explanation, thank you very much man!
The clearest explanation ❤
omg Colt thank you for explainin it and makes it easy to understand!
so easily and seamlessly explained. thank you so much
Damn SQL is so powerful... great job explaining this
You are the best!. clearly explained the Window functions
Very useful. Thank you! Where is the video in which you explain the lead() and lag() functions, please?
Best explanation by far!
wow! very nice tutorial🤩
this video is gem.
Thanks for explaining in such a nice way
One of the best on this topic. Thank you.
Great video! Thanks for explaining this so clearly!
Such a great video to understand this advaced concept. Thanks a bunch!!
Best explained.. Need more sql video
Nice , Easy explanation thank you
Wonderful crisp and clear
Thanks. This is so helpful though I still only know oracle Sql 😊
Woohoo! Glad to see you doing SQL
Very clear explanation! Thanks!
Very good explanation. Thank you!
Amazing window function explaination!! Thanks!
well explained thanks Colt...
Thank you for making it easy to understand.
Amazing explanation!
Great Explanations thnx 👍
Oh awesome! Thanks for posting a video on this totally was looking for more info on SQL window functions.
bro gave such a good explanation
We need an advanced SQL course!
Perfectly explained. Thanks
Very clear explanation thank you
Very nice explanation bro, keep going you.
Thanks,
clear and concise explanation 👌
Just perfect.
Very clear! Thank you Colt
Hi Colt! What is the setup you are using? (VSCode + ?)
Best video on this topic...
bro loved your content as always ,i have oa next week ,wish me luck!
This was brilliant, thank you so much!
Please make a video explaining how running total gets calculated with window function. I mean what is the inner working.
VERY GOOD EXPLANATION THANK YOU!
Can you also make a video for lead/lag? This was a great explanation