SQL Window Function | How to write SQL Query using Frame Clause, CUME_DIST

No video

SQL Window Function | How to write SQL Query using Frame Clause, CUME_DIST | SQL Queries Tutorial

Рет қаралды 361,970

techTFQ

Күн бұрын

Пікірлер: 727

@timmytesla9655 2 жыл бұрын

I never thought I would understand window functions so fast and easily like this. Thank you a million times.

@techTFQ 2 жыл бұрын

Glad this helped ☺️

@mukeshbarnwal2705 Жыл бұрын

turu

@cecille2341 Жыл бұрын

same

@thedataholics 11 ай бұрын

@@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)

@aperxmim 2 жыл бұрын

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.

@techTFQ 2 жыл бұрын

Thank you so much 🙏🏼 Glad to know you found this helpful 🙂

@saranrajv3 2 жыл бұрын

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 :)

@techTFQ 2 жыл бұрын

Glad it helped!

@amaalanoos838 2 жыл бұрын

This is how a tutorial should be. Concise and clear explanation. Greate Job!

@satyaece2007 2 жыл бұрын

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.

@techTFQ 2 жыл бұрын

Very happy to read this feedback Satya .. I am very glad you liked it .. 🙏🏼🙏🏼☺️

@sanjoysaha1697 2 жыл бұрын

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.

@techTFQ 2 жыл бұрын

Thank you Sanjoy. Appreciate the feedback

@uraniumu242 Жыл бұрын

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!

@artisartisworld8629 Жыл бұрын

one of the best and easy explanations, even better than what we pay for most of the Udemy courses.

@meghanaiitb 2 жыл бұрын

Hello Thaufiq, I’m on my SQL learning journey and came across your channel, thank the KZfaq 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.

@techTFQ 2 жыл бұрын

Hi Meghana , It means a lot to receive such amazing feedback.. thank you 🙏🏼 I am so glad my content helped you ..

@deepikameher9343 5 ай бұрын

Best video ever found on KZfaq!! 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 !!

@gojosatoru805 3 ай бұрын

What questions were asked ?

@tejaswi1995 2 жыл бұрын

In the context of "unbounded preceding and unbounded following", this was the only time I understood it. Thanks a lot

@techTFQ 2 жыл бұрын

Happy to know that :)

@vaibhavitatekar4700 21 күн бұрын

I love how you explained the frame clause. It's so easy to understand in your way. Thank you for that

@avikkarmakar2278 Жыл бұрын

The goto channel to learn SQL. As a non-tech person, I really appreciate the ease of learning and understanding the language

@sairamuddanda5816 2 жыл бұрын

Mind blowing!! Never come across this much clearer explanation in entire world which you have done it. Thanks for this

@techTFQ 2 жыл бұрын

Glad you liked it bro

@user-fz9ng3se4f Жыл бұрын

TechTFQ = Deep Understanding + Great knowledge + Impressive teaching style.

@mahipalrathod962 23 күн бұрын

Your way of explaining really easy to understand Thank you very much !!

@gulaggang6339 3 жыл бұрын

Great video. Looking forward to more advanced sql content. Thanks for the quality content.

@techTFQ 3 жыл бұрын

Thank you so much 🙏🏼 Truly appreciate your feedback. Yeah will cover other advanced SQL concepts ☺️

@gauravhawadiya6990 2 жыл бұрын

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 2 жыл бұрын

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

@samreenfathima6793 Жыл бұрын

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!!

@nomatusi7514 Жыл бұрын

nth_value is not working on my MS SQL. I copy the codes but still cannot work.

@monicanalawade3106 2 ай бұрын

Your way of exlanation is very simple. You are making SQL very simple and easy. Thank you for your efforts. You are just great.

@beulahr5740 Ай бұрын

very useful video. Thank you soooo very much sir

@anduamlaktadesse9284 Жыл бұрын

After now on, I can solve any complex problems using window functions . Big respect for you!

@nagarajshenoy4848 Ай бұрын

Unbounded preceding was a tricky one.. Loved the way you explained..

@swatisinha3230 3 жыл бұрын

Thank you for such a fine effort . Explained everything in detail :)

@techTFQ 3 жыл бұрын

Thanks a lot Swati 🙏🏼 Happy to know this helped ..

@kehagupta142 2 ай бұрын

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

@achmadthoriq4412 2 жыл бұрын

i like how the way you explain window function so easily for beginner. Thanks

@techTFQ 2 жыл бұрын

Thank you Thoriq 🙏🏼 Very happy to hear this

@pzuazu8636 Жыл бұрын

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.

@NewCurlyMB 9 ай бұрын

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.

@techTFQ 8 ай бұрын

Great to hear

@lenzamoya6297 Ай бұрын

This was awesome,you made window functions lesson easy for me.

@NEG0POS Ай бұрын

You have awesome skills in explaining complex concepts ! Thx

@lize.6122 7 ай бұрын

Many thanks for your invaluable contribution to the success of my SQL journey. You are such a lifesaver.

@tanmaysinghi1868 2 жыл бұрын

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 2 жыл бұрын

Thank you Tanmay 🙏🏼 Glad this helped

@saibalpatra01 Жыл бұрын

Both the tutorials of window function are gem of video. Really love the way you teach. Thank you so much

@nabilakhtar1048 Жыл бұрын

I just started learning SQL and this tutorial saved me. outstanding. Keep going

@techTFQ 3 жыл бұрын

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)

@aebirim9210 2 жыл бұрын

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!

@techTFQ 2 жыл бұрын

Glad it was helpful!

@udaykumar-dl6ux Жыл бұрын

All the window functions are very easy to understand. Thanks for explaining very clearly.

@ritikas383 2 жыл бұрын

I am so grateful that I stumbled upon this channel. Thank you for making it all so easy !

@techTFQ 2 жыл бұрын

You are so welcome! Glad it helped

@mateuszsmendowski2677 2 жыл бұрын

Literally the best channel about SQL on KZfaq :)

@techTFQ 2 жыл бұрын

I am glad you think so ☺️ Thank you 🙏🏼

@sudippandit9855 2 жыл бұрын

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😍

@techTFQ 2 жыл бұрын

Thank you Sudip 🙏🏼 I am so glad to know you liked my videos .. I’ll try my best to post more such useful videos ☺️

@aimanansarmomin4542 8 ай бұрын

Jazakallah khair.. i am learning sql by watching your videos thanks you are a best teacher.

@ramagirinikhil7383 6 ай бұрын

"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."

@swetagupta5539 2 жыл бұрын

Explanation was crystal clear. Thank you so much for sharing this video.

@techTFQ 2 жыл бұрын

Thank you :)

@rizf800 Жыл бұрын

most comprehensive and easy explanation of the most difficult query thank you so much❤❤❤

@ShubhashreeMunot Жыл бұрын

One of my favorite channel on you tube!! Quality content!!!!! Really Thankful to you for sharing this detailed knowledge on window function!

@sagnikchakraborti2415 5 ай бұрын

Your way of explanations through queries makes every concept interesting and inspires to learn more.

@niveditav691 Жыл бұрын

Undoubtedly you have the best video explaining window functions !!

@sonicasinha Жыл бұрын

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 !!

@IrakliChitishvili 3 жыл бұрын

Great video series, good job! For added bonus - new chapter title intros sound like a slap haha :D. definitely subscribing.

@techTFQ 3 жыл бұрын

Haha dint realize it sounds like a slap .. Still figuring out how to make the video quality better .. But thanks for liking the content 🙏🏼👍

@madhusmitatripathy8767 2 жыл бұрын

kudos to your presentation. Very clear ..loved this..

@techTFQ 2 жыл бұрын

Thank you 🙏🏼 Glad you liked it

@gowthaman3264 2 жыл бұрын

Thanks For the video, anyone can learn SQL if you teach ...Please post more videos...

@techTFQ 2 жыл бұрын

Thank you very much ☺️

@anjanaray1594 3 жыл бұрын

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.

@techTFQ 3 жыл бұрын

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..

@alkaaswar1780 Жыл бұрын

You are such a great person who are providing this all the helpful knowledge freely Thank you so much

@stevenpalm9484 2 жыл бұрын

You are a great instructor. Thanks for sharing.

@techTFQ 2 жыл бұрын

Thank you once again Steven 🙏🏼

@karennguyen7083 2 жыл бұрын

Clear explanation. Look forward to watching your following videos. Thanks.

@techTFQ 2 жыл бұрын

Awesome, thank you!

@pasupulativyshnavi8271 Жыл бұрын

One of my favourite KZfaq channel.tanq so much brother for making such excellent videos for beginners.tanx is not enough for your efforts brother 🙌🙌🙌🙌🙌

@manic-uq9si Жыл бұрын

Excellent teaching sir TQ very much

@Laavanyablogs 11 күн бұрын

Thank you When student is ready to learn master will be there

@SiddhirupaNanda 3 ай бұрын

Wow! I understand your content on SQL very easily. Thank you very much. Keep making videos!

@kebincui 2 жыл бұрын

Explaination Crystal clear. Thanks for sharing

@techTFQ 2 жыл бұрын

Your welcome 🙏🏼 Glad this helped

@davidgitau8825 2 жыл бұрын

One of the best video of windowing functions done! Keep it up.

@techTFQ 2 жыл бұрын

Thanks a lot!

@sandeepmandavilli4512 2 жыл бұрын

you are saving my interviews , thank you for these amazing videos

@techTFQ 2 жыл бұрын

Your welcome buddy Glad this is helping

@user-pl4xo3cc9t 10 ай бұрын

The way you explain the things makes it very easy to understand the functions. Thanks alot.

@techTFQ 8 ай бұрын

You're welcome

@story_teller_Is 11 ай бұрын

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.

@aryamohit6496 Жыл бұрын

you explained things in very simplified way, Thanks My search for advanced topics for sql stopped here.

@abhiannamreddy5050 Жыл бұрын

Easy explanation just pay attention . Thank you for your help in the past window functions looks like unattinable gold to me.

@sidharthpradhan155 2 ай бұрын

You are doing great job, hats off man for this kind of effort and knowledge you are providing

@Health4U252 2 жыл бұрын

Very Useful, Thank you for your help and hard work!!

@techTFQ 2 жыл бұрын

Glad you liked it 🙏🏼

@SidhantPatra Ай бұрын

It was so clear and understandable. Thank you so much for such valuable topic🤗

@bhargavpaluri6858 2 жыл бұрын

Explanation is too good.making every concept look easy.

@techTFQ 2 жыл бұрын

Glad you liked it

@kuldeeppatil9680 3 ай бұрын

Thanks toufiq for thus great tutorial

@ektabangar4094 5 ай бұрын

This is the best video on Window function I have ever came across. Kudos to you!!

@anujshah7350 Жыл бұрын

your voice and way of teaching don't let anyone go away from the long video length as well. Keep up (y)

@gowthamsagarkurapati9388 2 жыл бұрын

The concepts are very clear, Thank you for explaining!

@techTFQ 2 жыл бұрын

Glad to hear that ☺️

@wrenggorwagnac5948 Жыл бұрын

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.

@rajarani657 Жыл бұрын

I like your way of teaching, it is very easy to understand. Thank you very much.

@AbhishekSharma-dn5us 2 жыл бұрын

You made it look like super easy, big thanks

@techTFQ 2 жыл бұрын

You’re welcome 😊

@eran3851 2 жыл бұрын

Thank You very much. I learned a lot from this video.

@linnynguyen 5 ай бұрын

this video is better than any other one in the same topic. Million thanks!

@sribastavrajguru304 2 жыл бұрын

For percent_rank, you said "GZ fold is 80 percent more expensive than other products". But that is a bit ambiguous as far as my understanding, it should be "GZ fold is expensive than 80 percent of the products". Thanks for the amazing explanations, as always

@techTFQ 2 жыл бұрын

Yes you are right.. I mis interpreted it in the video.. and thanks for liking the content

@hammadyasir2174 2 ай бұрын

Thanks a lot! Complex window functions become so much easier through your explanations. You should consider uploading your content to Coursera. It's a suggestion because I've seen that most big companies explain things at an abstract level, not a deep level, which can disadvantage learners. Thanks again!

@himanshumittal1265 7 ай бұрын

@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!

@TeamEnneser 10 ай бұрын

Easy explanations. No self advertisement. Absolutely Professional. Good Work Mate

@anirvansen5024 2 жыл бұрын

Your explanation on rows between and range between is so clear, Thank you so much :)

@techTFQ 2 жыл бұрын

Your welcome 🙏🏼 Glad this helped

@jeffp9091 Жыл бұрын

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!!

@surisettilakshmiprasanna1531 Жыл бұрын

Sir this video is really helpful for me .Thank you so much

@Olashileayomi Жыл бұрын

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.

@sreekala Жыл бұрын

Very well explained! Video is just long and with great details.

@muhammadwaqar3406 9 ай бұрын

God bless. I just did your videos before my interview and cleared it! Great stuff keep it up. subscribed

@techTFQ 8 ай бұрын

Glad it helped :)

@nagulapallykumar2401 2 жыл бұрын

Superb videos please make more videos

@techTFQ 2 жыл бұрын

Thank you and sure will do

@simizcodding4487 Жыл бұрын

your channel is one of the best..please make series on projects with sql ..thanks alot for this wonderful explanation

@shreepadjoshi5142 7 ай бұрын

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.

@dobijr7900 6 ай бұрын

pls can i get the codes for this particular video....thank you