@@techTFQ does the way of window clause not work in SQL SERVER as I am getting error while doing so?? Below is the query I am using @techtfq select distinct product_category, FIRST_VALUE(product_name) over w as most_expensive_product_in_each_category, FIRST_VALUE(price) over w as price_of_most_expensive_product, LAST_VALUE(product_name) over w as least_expensive_product_in_each_category, LAST_VALUE(price) over w as price_of_least_expensive_product from products window w as (partition by product_category order by price desc range between unbounded preceding and unbounded following)
This is about easy as it gets to understand, just need to practice so these techniques could stay inside my brain. Good Job, better than most college professor teachings.
I have searched Udemy and many youtube channels to understand the Window functions and finally this video shed the light for an excellent clarity , Once again kudos to Taufiq for an excellent content and clarification :)
I have explored so many courses on udemy and on other online platforms but yours is unparallel. Excellent explanation, easy to understand making it stand out from the crowd. You rock man. Thanks for sharing the videos.
Hello Thaufiq, I’m on my SQL learning journey and came across your channel, thank the TH-cam algo lords. Previously, I used to refer to the documentation pages to learn SQL and would easily get lost in understanding nuances. Your succinct explanation on LAST_VALUE() default frame just saved me loads of time. Huge thanks. Subscribed.
Best video ever found on TH-cam!! I was scared of SQL queries for all interviews,after going through your videos I have got confidence and creaked interviews as well...Many many thanks to you...the way you explain is superb...Kudos to you !!
I completed a course on advanced sql windows functions on linkdin and in 15 minutes of your video i understood more than i did in that entire course!! kudos to you. I cannot thank you enough !! really really appreciate !! need more tutors like you!!
Exceptionally articulated starting with every query and data set explanation and I can't believe it's so easy after hearing to your explanation and it's impressive. It's not easy to watch an hour of new concept continuously but your videos are exception. It's really interesting though I'm pretty new to these concepts. Thanks a lot for making these videos.
this is the first video on youtube i have seen so far that has 1000 likes and 0 dislike as on december 12th , 2021.... indeed a great video and great teacher......
@techTFQ - I have paid a hefty amount to an ed-tech company to learn SQL, but believe me when I say, this is far far better explanation then those nincompoops. Kudos to you!
Download all the SQL Queries, Table structure and Table data used in this video from my website. Link below: techtfq.com/video/sql-window-function-sql-queries-tutorial-part-2 Click on the button which says "Download SQL Script" to download the .sql file (.sql file can be opened in any text editor)
My good sir, I've been binge watching your videos. Got my Google Analytics diploma and I need as much practical knowledge and practice as I can get my hands on. THANK VERY MUCH for these videos.
I watched both of your videos on window functions. You have a way of making something that seems complicated, 😂easy to learn. You’re a very good teacher. Thanks for your help.
For the PERCENT RANK window function example, I believe this would answer the question - How expensive the phone is with regards to the most expensive product rather than how expensive the phone is compared to all the phones(As every phone will have a different price). Liked the content and examples. Thank you.
This is an excellent video. This explains to me why my SQL queries have been delivering funny results. That bit about unbounded preceding and unbounded following is priceless!
After going through numerous videos on sql and trying to find the best one to understand the concept I found this, truly a gem. quality content easy to understand simplified language is used. watching your videos continuously more than 2 hours. Thanks a lot. please do create projects on sql too after all the concepts.
Thanks a lot Anjana 🙏🏼🙏🏼 Amazing to receive such feedback .. I am so so glad you liked the video and have benefited from it.. Surely will be making some videos on SQL projects in the near future..
You are such an exceptional Teacher....very precise to the concepts and explanation is crisp and clear...Thank you..SQL learning is more easy when I hear from you.
your videos have been extremely helpful so far, thank you so much for all this, I wasn't just able to get a quick revision of SQL but also learn few advance concepts.
@techTFQ- Awesome, great job, I have been working in IT as a developer from 5 years but still I do watch your videos on Advance sql topics and those are amazing.
Really great video. I think it helped that I wasn't totally new to window functions, but this tied everything together. Very thorough. Thank you thank you!!
Thank you for your contribution! I really love to see those contributions so that it will make easy to understand the real time projects. Please keep going your good work and hope to see the other more videos like this in the upcoming days😍
I never thought I would understand window functions so fast and easily like this. Thank you a million times.
Glad this helped ☺️
turu
same
@@techTFQ
does the way of window clause not work in SQL SERVER as I am getting error while doing so??
Below is the query I am using
@techtfq
select distinct product_category,
FIRST_VALUE(product_name) over w as most_expensive_product_in_each_category,
FIRST_VALUE(price) over w as price_of_most_expensive_product,
LAST_VALUE(product_name) over w as least_expensive_product_in_each_category,
LAST_VALUE(price) over w as price_of_least_expensive_product
from products
window w as (partition by product_category order by price desc range between unbounded preceding and unbounded following)
@@techTFQ p0llo
This is about easy as it gets to understand, just need to practice so these techniques could stay inside my brain. Good Job, better than most college professor teachings.
Thank you so much 🙏🏼
Glad to know you found this helpful 🙂
This is how a tutorial should be. Concise and clear explanation. Greate Job!
I have searched Udemy and many youtube channels to understand the Window functions and finally this video shed the light for an excellent clarity , Once again kudos to Taufiq for an excellent content and clarification :)
Glad it helped!
I hav spent a lot of money on books a courses but you are the best teacher. I have learned things that were skimmed over elsewhere. Thank you!
The goto channel to learn SQL. As a non-tech person, I really appreciate the ease of learning and understanding the language
In the context of "unbounded preceding and unbounded following", this was the only time I understood it. Thanks a lot
Happy to know that :)
I have explored so many courses on udemy and on other online platforms but yours is unparallel. Excellent explanation, easy to understand making it stand out from the crowd. You rock man. Thanks for sharing the videos.
Thank you Sanjoy.
Appreciate the feedback
Hello Thaufiq, I’m on my SQL learning journey and came across your channel, thank the TH-cam algo lords. Previously, I used to refer to the documentation pages to learn SQL and would easily get lost in understanding nuances. Your succinct explanation on LAST_VALUE() default frame just saved me loads of time. Huge thanks. Subscribed.
Hi Meghana ,
It means a lot to receive such amazing feedback.. thank you 🙏🏼
I am so glad my content helped you ..
Best video ever found on TH-cam!! I was scared of SQL queries for all interviews,after going through your videos I have got confidence and creaked interviews as well...Many many thanks to you...the way you explain is superb...Kudos to you !!
What questions were asked ?
I completed a course on advanced sql windows functions on linkdin and in 15 minutes of your video i understood more than i did in that entire course!! kudos to you. I cannot thank you enough !! really really appreciate !! need more tutors like you!!
nth_value is not working on my MS SQL. I copy the codes but still cannot work.
TechTFQ = Deep Understanding + Great knowledge + Impressive teaching style.
You sir are a God send. My number 1 port of call when i need sql explained in plain English. On behalf of all your viewers here's a massive THANK YOU.
Exceptionally articulated starting with every query and data set explanation and I can't believe it's so easy after hearing to your explanation and it's impressive. It's not easy to watch an hour of new concept continuously but your videos are exception. It's really interesting though I'm pretty new to these concepts. Thanks a lot for making these videos.
Very happy to read this feedback Satya ..
I am very glad you liked it ..
🙏🏼🙏🏼☺️
this is the first video on youtube i have seen so far that has 1000 likes and 0 dislike as on december 12th , 2021.... indeed a great video and great teacher......
Thank you Gaurav 🙏🏼
I had not notice it .. it’s so nice you did and mentioned it here .. I am glad you liked the content ☺️
Thanks again
@techTFQ - I have paid a hefty amount to an ed-tech company to learn SQL, but believe me when I say, this is far far better explanation then those nincompoops. Kudos to you!
Download all the SQL Queries, Table structure and Table data used in this video from my website. Link below:
techtfq.com/video/sql-window-function-sql-queries-tutorial-part-2
Click on the button which says "Download SQL Script" to download the .sql file (.sql file can be opened in any text editor)
After now on, I can solve any complex problems using window functions .
Big respect for you!
one of the best and easy explanations, even better than what we pay for most of the Udemy courses.
I just started learning SQL and this tutorial saved me. outstanding. Keep going
I love how you explained the frame clause. It's so easy to understand in your way. Thank you for that
Mind blowing!! Never come across this much clearer explanation in entire world which you have done it. Thanks for this
Glad you liked it bro
Your way of exlanation is very simple. You are making SQL very simple and easy. Thank you for your efforts. You are just great.
Now finally I am able to understand completely how and where to use window functions in such a easy way. Thanks a lot for an amazing tutorial !!
Jazakallah khair.. i am learning sql by watching your videos thanks you are a best teacher.
My good sir, I've been binge watching your videos. Got my Google Analytics diploma and I need as much practical knowledge and practice as I can get my hands on. THANK VERY MUCH for these videos.
"I am so thankful to you because your videos have made me more interested in learning SQL. I love the way you explain the topics using simple words."
I watched both of your videos on window functions. You have a way of making something that seems complicated, 😂easy to learn. You’re a very good teacher. Thanks for your help.
Great to hear
Many thanks for your invaluable contribution to the success of my SQL journey. You are such a lifesaver.
i like how the way you explain window function so easily for beginner. Thanks
Thank you Thoriq 🙏🏼
Very happy to hear this
default frame k concept p youtube m v bht kam videos hn., but iss vdo m bht mast explanation k sath default frame v clear hogya.
Literally the best channel about SQL on TH-cam :)
I am glad you think so ☺️
Thank you 🙏🏼
Both the tutorials of window function are gem of video. Really love the way you teach.
Thank you so much
For the PERCENT RANK window function example, I believe this would answer the question - How expensive the phone is with regards to the most expensive product rather than how expensive the phone is compared to all the phones(As every phone will have a different price). Liked the content and examples. Thank you.
pls can i get the codes for this particular video....thank you
I used to think , SQL is so dam tough but not anymore. You are just too good
This is an excellent video. This explains to me why my SQL queries have been delivering funny results. That bit about unbounded preceding and unbounded following is priceless!
Glad it was helpful!
you are a great mentor . At first these things were very confusing for me but now i am confident enough to use them. Thank you
It's is very tough for understand window function but when I landed here ..finally fear of window function gone ..thanku for videos.
After going through numerous videos on sql and trying to find the best one to understand the concept I found this, truly a gem. quality content easy to understand simplified language is used. watching your videos continuously more than 2 hours. Thanks a lot. please do create projects on sql too after all the concepts.
Thanks a lot Anjana 🙏🏼🙏🏼
Amazing to receive such feedback .. I am so so glad you liked the video and have benefited from it..
Surely will be making some videos on SQL projects in the near future..
This is the best video on Window function I have ever came across. Kudos to you!!
most comprehensive and easy explanation of the most difficult query thank you so much❤❤❤
Undoubtedly you have the best video explaining window functions !!
THE BEST video for the window function
One of my favorite channel on you tube!!
Quality content!!!!! Really Thankful to you for sharing this detailed knowledge on window function!
this video is better than any other one in the same topic. Million thanks!
All the window functions are very easy to understand. Thanks for explaining very clearly.
Great video. Looking forward to more advanced sql content. Thanks for the quality content.
Thank you so much 🙏🏼
Truly appreciate your feedback. Yeah will cover other advanced SQL concepts ☺️
3 yers later and still relevant great job
You are such a great person who are providing this all the helpful knowledge freely Thank you so much
You are such an exceptional Teacher....very precise to the concepts and explanation is crisp and clear...Thank you..SQL learning is more easy when I hear from you.
your videos have been extremely helpful so far, thank you so much for all this, I wasn't just able to get a quick revision of SQL but also learn few advance concepts.
Thank you Tanmay 🙏🏼
Glad this helped
Explanation was crystal clear. Thank you so much for sharing this video.
Thank you :)
It was a detailed explanation, including the formulas, which made the concept much clearer. Many thanks! 🙂
Easy explanations. No self advertisement. Absolutely Professional. Good Work Mate
you are saving my interviews , thank you for these amazing videos
Your welcome buddy
Glad this is helping
Your way of explanations through queries makes every concept interesting and inspires to learn more.
Unbounded preceding was a tricky one.. Loved the way you explained..
explanation of the frame was just amazing!
thank you so much !!
I am so grateful that I stumbled upon this channel. Thank you for making it all so easy !
You are so welcome!
Glad it helped
Explaination Crystal clear. Thanks for sharing
Your welcome 🙏🏼
Glad this helped
you explained things in very simplified way, Thanks
My search for advanced topics for sql stopped here.
Able to understand each window formula within 2 videos using OVER clause...Thanks brother for such an informative video!!! Keep it up!!
Your welcome vinay 🙏🏼
Happy to know this helped
One of the best video of windowing functions done! Keep it up.
Thanks a lot!
your sql master guide for beginners. toufiq sir.
your voice and way of teaching don't let anyone go away from the long video length as well. Keep up (y)
The way you explain the things makes it very easy to understand the functions. Thanks alot.
You're welcome
Clear explanation. Look forward to watching your following videos. Thanks.
Awesome, thank you!
@techTFQ- Awesome, great job, I have been working in IT as a developer from 5 years but still I do watch your videos on Advance sql topics and those are amazing.
Excellent teaching sir TQ very much
You are such an amazing teacher. Thank you so much.
EXECELLENT EXPLAINATION.....VERY EASY TO UNDERSTAND..THANK YOU SO MUCH...GREAT EFFORTS....
Explanation is too good.making every concept look easy.
Glad you liked it
You are a great instructor. Thanks for sharing.
Thank you once again Steven 🙏🏼
Wow! I understand your content on SQL very easily. Thank you very much. Keep making videos!
Really great video. I think it helped that I wasn't totally new to window functions, but this tied everything together. Very thorough. Thank you thank you!!
Fantastic stuff. Better than paid courses. Thanks man.
I'm so glad I stumbled upon your page. My queries skills have improved a lot watching your videos. Keep doing the good work Taofiq.
Best video on window functions that I've ever seen.
Keep up the good work!!
Thank you Sidhant 🙏🏼
Appreciate the feedback ☺️
I like your way of teaching, it is very easy to understand. Thank you very much.
Thank you for your contribution! I really love to see those contributions so that it will make easy to understand the real time projects. Please keep going your good work and hope to see the other more videos like this in the upcoming days😍
Thank you Sudip 🙏🏼
I am so glad to know you liked my videos ..
I’ll try my best to post more such useful videos ☺️
I'm new in sql and your videos are really helpful!
Thanks a lot
I can't believe how helpful this is. Such a brilliant job. Thank you immensely.
Such a good explanation of Window Functions. Thank you!
Outstanding Sir. Thank you for your both Windows functions videos..
WORLD BEST TUTOR.
Your way of explaining really easy to understand
Thank you very much !!
Respect from the bottom of my heart, Thank you so much for this video. Just wow🤩
best explanation ever seen about window functions. keep rocking sir...
Very much understandable. Examples and explanation was too good. Thank you very much for such an wonderful explanation
Your welcome Priya ..
Glad this helped
I watched several videos, your is the best
Thank you Rishav 🙏🏼
Glad you liked it ..
Simply mind blowing explanation! Thanks for being a great mentor. Much love and health to you!
Thank you for such a fine effort . Explained everything in detail :)
Thanks a lot Swati 🙏🏼
Happy to know this helped ..
wonderful video with a very detailed explanation. thank you
Glad you liked it 🙏🏼☺️
Thanks toufiq for thus great tutorial
Excellent teaching... understood in one go ..
The concepts are very clear, Thank you for explaining!
Glad to hear that ☺️
very useful video. Thank you soooo very much sir
The explanation is simple and upto the point. I am glad I found this channel. Btw that slap sound is quite funny during intro to new functions. 😂
best SQL channel
best video on window functions!! thank uu brother ...