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
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
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!
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.
@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.
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
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👍
I have never seen anyone explain this so clearly. Thank you so much
You are absolutely right, I must admit
thats true
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
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'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!
After struggling for 2+ hrs, came here and you cleared it up in 10 mins. Thank you, thank you, thank you!!
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.
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.
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.
Best ever video that I saw over any platform regarding SQL window functions.....
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 😂😅
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!
Hi, I have bought ur course in udemy. Thanks for all your effort. Great teacher!
This is the best video on window funcitons i've ever watched. Thankyou for making the concept clear.😇
This explanation is everythingggg!! Thank you Colt.
the best explanation on window functions I`ve ever seen, thanks
It's the best explanation of the Window Functions that I've seen. Thank you so much!
Literally the best explanation so far
Hey Mr. Colt, great explanation concise and clear. I'll keep following your work.
Cheers.
The best lecture on window functions EVER. Thanks Colt!
I don't usually write comments, I'm sleepy and my brain is working in 2 cells but I still got it. Great explanation.
Wow! This was gold standard explanation. Thanks a lot.
Best explanation of the world!!!, so happy that I could dance with a wheelchair
This is TOP TIER explanation, thank you so much!
glad i clicked this as my first video about window function 😊
Within 10 minutes, I got what I needed. Excellent presentation. Wish you made videos on advanced SQL like cte...
So far, the best SQL Window functions video. Thanks you so much!
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. 😉
A simple clear explanation, finally I got it! Thanks
Great video - the explanation, the visuals you use,... Thank you!
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 spent over an hour not understanding this until now. Thank you!
Super clear explanation, in 2 minutes I had understood, thanks!
This was absolutely perfectly clear. Thanks for your work
This is a very clear explanation. Thank you!
@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.
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
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👍
I like the last sentence in the video. great explanation.
Awesome explanation and demonstration. I finally understand OVER() more. Thank you!
so easily and seamlessly explained. thank you so much
Dude. You're a lifesaver!
The most understandable explanation about window functions ever
lifesaver omg thank you so much for the side by side comparison of group by vs window
You are the best!. clearly explained the Window functions
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.)
Great lecture, clear and concise 👍
Instant sub! Didn't even have to rewatch, this was SO clear. Thank you so much!!
Amazing video. So much given in just 10 minutes. I'll definitely buy the Udemy course.
One of the best on this topic. Thank you.
Best explanation by far!
So great. Thanks. I wish you would have also covered cumulative sums though too because I am using that now.
The clearest explanation ❤
Dude this was so well explained, thanks man
omg Colt thank you for explainin it and makes it easy to understand!
Nice , Easy explanation thank you
Damn SQL is so powerful... great job explaining this
Such a great video to understand this advaced concept. Thanks a bunch!!
Thanks for explaining in such a nice way
It was sooooo clear, AMAZING explanation, thank you very much man!
Best explained.. Need more sql video
Amazing window function explaination!! Thanks!
Great video! Thanks for explaining this so clearly!
Very good explanation. Thank you!
wow! very nice tutorial🤩
Wonderful crisp and clear
Very clear explanation! Thanks!
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
Perfectly explained. Thanks
Thank you for making it easy to understand.
well explained thanks Colt...
Very clear explanation thank you
VERY GOOD EXPLANATION THANK YOU!
Woohoo! Glad to see you doing SQL
Very nice explanation bro, keep going you.
WE NEED THAT ADVANCED SQL COURSE KING!!
Very clear! Thank you Colt
Amazing explanation!
This was brilliant, thank you so much!
Best video on this topic...
Oh awesome! Thanks for posting a video on this totally was looking for more info on SQL window functions.
Great video. Thank you for sharing!
Very clear, thank u 4 ur effort!
very good explanations, thank you
this video is gem.
bro loved your content as always ,i have oa next week ,wish me luck!
very useful, thanx for the efforts
Thanks,
clear and concise explanation 👌
Just perfect.
Excelletnt and to the point explanation
bro gave such a good explanation
Thanks. This is so helpful though I still only know oracle Sql 😊
Very solid explanation, Thanks mate
Very well explained. Thank you!