SQL Window Function | How to write SQL Query using RANK, DENSE RANK, LEAD/LAG | SQL Queries Tutorial

Поділитися
Вставка
  • Опубліковано 26 чер 2024
  • This video is about Window Functions in SQL which is also referred to as Analytic Function in some of the RDBMS. SQL Window Functions covered in this video are RANK, DENSE RANK, ROW NUMBER, LEAD, LAG. Also, we see how to use SQL Aggregate functions like MIN, MAX, SUM, COUNT, AVG as window function.
    This video is focused on teaching how to write SQL Queries using different window functions or analytic functions. We go through the syntax of using rank, dense_rank, row_number, lead, lag and max functions as window function.
    Over clause is explained in detail in this video. Over clause is used in SQL when we need to use window function. Inside Over clause, we also use Partition By clause and also Order by clause.
    Partition By clause is used to specify the column based on which different windows needs to be created.
    The window function you learn in this video is applicable to any RDBMS since these functions are commonly used across most of the popular RDBMS such as Oracle, MySQL, PostgreSQL, Microsoft SQL Server etc.
    Download all scripts and Queries used in this video from below link:
    techtfq.com/blog/sql-window-f...
    Click on the "Download SQL Script" button to download scripts.
    Timestamp:
    00:00 Intro
    01:33 Understanding Aggregate function
    03:16 Syntax to write SQL Query using Window Function
    06:33 ROW_NUMBER() Window Function in SQL
    11:57 RANK() Window Function in SQL
    15:43 DENSE_RANK() Window Function in SQL
    17:10 Difference between RANK, DENSE RANK and ROW NUMBER in SQL
    17:59 LEAD() and LAG() Window Function in SQL
    I hope this video was helpful and gives you a good understanding of how to write SQL Queries using window functions or analytic functions. If you liked what you saw, then please make sure to like, subscribe and comment any feedback you may have.
    Also please do not hesitate to share the video with your friends and colleagues who may be interested in learning SQL
    🔴 WATCH MORE VIDEOS HERE 👇
    ✅ SQL Tutorial - Basic concepts:
    • SQL Tutorial - Basic c...
    ✅ SQL Tutorial - Intermediate concepts:
    • SQL Tutorial - Interme...
    ✅ SQL Tutorial - Advance concepts:
    • SQL Tutorial - Advance...
    ✅ Practice Solving Basic SQL Queries:
    • Practice Solving BASIC...
    ✅ Practice Solving Intermediate SQL Queries:
    • Practice Solving INTER...
    ✅ Practice Solving Complex SQL Queries:
    • Practice Solving COMPL...
    ✅ Data Analytics Career guidance:
    • Data Analytics career ...
    ✅ SQL Course, SQL Training Platform Recommendations:
    • SQL Course / Training
    ✅ Python Tutorial:
    • Python Tutorial
    ✅ Git and GitHub Tutorial:
    • Git and GitHub
    ✅ Data Analytics Projects:
    • Data Analytics Projects
    THANK YOU,
    Thoufiq

КОМЕНТАРІ • 1,4 тис.

  • @Egitam-ow7ih
    @Egitam-ow7ih Місяць тому +41

    Watching his videos I successfully cracked two interviews of Amazon for Data Engineer role , and secured internship.

  • @osamaraheem9524
    @osamaraheem9524 2 роки тому +75

    You explain every things in a clear English, I think this is one of the finest tutorial on UA-cam... Keep it Up

    • @techTFQ
      @techTFQ  2 роки тому +8

      Thank you Raheem 🙏🏼
      Glad you liked it 🙂

  • @ms_avb
    @ms_avb 2 роки тому +1

    amazing. i’ve been struggling with window functions and your 25min video has explain it better than a whole day of course material. thanks so much!!!!

  • @hellookim
    @hellookim 3 роки тому +207

    This was super helpful and easy to follow! I'm currently studying SQL and this was the best explanation of windows functions I came across. Would love to see more videos on SQL!

    • @techTFQ
      @techTFQ  3 роки тому +6

      Thanks a lot for such kind words 🙏🏼
      So glad to hear that you found it useful ☺️

    • @favourebubechukwu3592
      @favourebubechukwu3592 2 роки тому +3

      Agree!

    • @techTFQ
      @techTFQ  2 роки тому +3

      Thank you 🙏🏼

    • @meiwarcadey2172
      @meiwarcadey2172 2 роки тому +1

      Thank you so much it is helpful please make more videos on functions in oracle sql

    • @techTFQ
      @techTFQ  2 роки тому +1

      Thank you 🙏🏼 sure will do

  • @souryapattanayak9698
    @souryapattanayak9698 2 роки тому +52

    One of best demonstration with absolute clarity about the windowing concept. Thank you for the simplest/easiest explaination of this complex concepts.

    • @techTFQ
      @techTFQ  2 роки тому

      Thank you so much 🙏🏼
      Means a lot to receive such positive feedback ☺️☺️

  • @utkarshkunwar4319
    @utkarshkunwar4319 2 роки тому +14

    This tutorial, right here, is one of the best to learn what Window Functions are

    • @techTFQ
      @techTFQ  2 роки тому

      Thank you Utkarsh for such encouraging feedback 🙏🏼
      So glad you liked it..

  • @fatemehsefishahpar3626
    @fatemehsefishahpar3626 2 роки тому +1

    The most clearest way of explaining window function! Bravo!

  • @emilyshi9417
    @emilyshi9417 10 місяців тому +1

    This is the most straightforward version of the window function I ever learned. Super helpful! Please teach more advanced SQL language in this channel.

  • @faridhussain3281
    @faridhussain3281 2 роки тому +24

    I am a new SQL learner. So, I saw many videos on SQL tutorials. But, I found your one very helpful and effective. I was struggling with the Window function so hard that I thought I would give up learning SQL. But, your video makes it very simple to me. I am really impressed with your videos. Keep it up.

    • @techTFQ
      @techTFQ  2 роки тому +1

      Thank you so much buddy 🙏🏼
      It means a lot to receive such positive feedback ☺️
      I am so glad this helped you..

  • @jonathanbroyles9247
    @jonathanbroyles9247 2 роки тому +3

    This was an extremely helpful review of all the listed window functions. The clear walkthrough of each function and how they interact with each other was done exceptionally well. I was having issues using the lag function correctly and this answered every one of my questions. Looking forward to watching more of your SQL videos! Subscribed!
    Thank you!

    • @techTFQ
      @techTFQ  2 роки тому +1

      Your welcome Jonathan ..
      I am glad to read your feedback ☺️

  • @swathikota
    @swathikota 9 місяців тому

    Absolutely brilliant and crisp way of explanation. I had never studied about window functions so far and I just checked your tutorial video to learn, I got crystal clear clarity about window functions - their syntax, usage, scenarios where it can be used. Truly impressed with your teaching skills. Keep teaching, you are doing a great job.

  • @test-hj9lx
    @test-hj9lx 2 роки тому +1

    This has become my reference link to revise window functions fundamentals before any sql interview round. Thanks much !

  • @mohammedshahil4898
    @mohammedshahil4898 3 роки тому +41

    Hey brother, Just love the concepts you cover. I could easily understand these window functions. Credits to your teaching skills. You make it so simple and fun. Since i primarily work on SQL, this video was really helpful. Please make more videos on other window functions/advance SQL concepts. Cheers ✌🏻

    • @techTFQ
      @techTFQ  3 роки тому +3

      Thank you Shahil ❤️❤️
      Good to know you benefited from this..
      Sure will try to cover other functions in another video..

  • @bathini14
    @bathini14 2 роки тому +62

    I would have clear the interview today, if I had watched this before ..

    • @techTFQ
      @techTFQ  2 роки тому +19

      Sorry to hear you didn’t clear this time but I hope you get a better opportunity very soon ..
      Thank you for liking my video🙏🏼

    • @samratsingha8515
      @samratsingha8515 5 місяців тому +2

      @@techTFQsir I want to study your python courses if under my budget Please let me know sir. Thank you

    • @sandesh8197
      @sandesh8197 3 місяці тому

      Same story here

    • @ebadulislam123
      @ebadulislam123 Місяць тому

      I was also asked the same question of finding the top 3 employees from each dept. Sad, I didn't know window functions then.

  • @beardy.weirdo
    @beardy.weirdo 11 місяців тому

    I have been struggling with understanding window function for a really really really long time. But just one video of yours has made the concepts crystal clear to me. Thanks a lot!

  • @aniqahmed7204
    @aniqahmed7204 Рік тому +1

    You are an absolute legend for explaining window functions in detail. Thank you so much.

  • @harshmishra026
    @harshmishra026 2 роки тому +8

    I've search a lot about window function on Google and UA-cam but this tutorial is far better than others. It has helped me a lot . What a easy way to explain.✌

    • @techTFQ
      @techTFQ  2 роки тому

      Thank you Harsh. glad you liked it :)

  • @apostleisaacopokuagyeman5676
    @apostleisaacopokuagyeman5676 Рік тому +4

    This gentleman is very practical and a good teacher of SQL. It feels like in person lesson.

    • @techTFQ
      @techTFQ  Рік тому

      Thank you so much Isaac 🙏🏼

  • @zacramer
    @zacramer 3 місяці тому

    I'm preparing for an SQL intensive position and this is a phenomenal overview of windows functions. You provide an overview of the logic then how to apply them to real business questions. Great job!

  • @alexharris2375
    @alexharris2375 2 роки тому +1

    Very well done, thank you. I’ve always just ignored Rank because I thought row number does the exact same thing but you’ve helped realize where rank can really be useful.

  • @monishnagarajan5917
    @monishnagarajan5917 Рік тому +4

    It was an clear explanation with understandable examples, which will be very helpful especially for beginners like me 👏

  • @animeshmishra4282
    @animeshmishra4282 Рік тому +6

    Perfectly Splendid ❄️☕❄️ .
    I am newly deployed data engineer and I loved how you crafted this concept in simple approach

    • @techTFQ
      @techTFQ  Рік тому

      Thank you , glad this helped

  • @kehagupta142
    @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

  • @zhongqisun9082
    @zhongqisun9082 2 роки тому

    Your tutorial helps a lot! Make window function so easy and simple! Thank you!

  • @Innovade
    @Innovade 2 роки тому +6

    This is the best video I’ve found explaining window functions. Thank you for your help! I really appreciate it

    • @techTFQ
      @techTFQ  2 роки тому

      Thanks a lot for the positive feedback 🙏🏼
      Much appreciated and so glad the video helped ☺️

  • @jollypareira688
    @jollypareira688 3 роки тому +18

    Your new subscriber. One of the best channel I came across in learning SQL. You deserve much more subscribers

    • @techTFQ
      @techTFQ  3 роки тому +1

      Woww you made my day by such positive feedback ☺️.. thanks a lot and so happy this video helped you 🙏🏼

    • @jollypareira688
      @jollypareira688 3 роки тому +1

      @@techTFQ Thanks to you too for making good contents. Wishinh you all the luck

    • @techTFQ
      @techTFQ  3 роки тому

      @@jollypareira688 thank you again 🙏🏼

  • @deeprajsarkar3689
    @deeprajsarkar3689 Рік тому

    taufeeq the clarity of your teaching is supreme..thank you..

  • @alisonhenley2551
    @alisonhenley2551 Рік тому

    Wonderful and straight to the point! Great examples!

  • @aperxmim
    @aperxmim 2 роки тому +4

    Great training, straight to the point, clear examples.

    • @techTFQ
      @techTFQ  2 роки тому

      Thank you 🙏🏼
      Glad you liked it..

  • @amareshsahoo6003
    @amareshsahoo6003 2 роки тому +3

    This tutorial, right here, is one of the best to learn what Window Functions are.
    Background slow music is awesome.

    • @techTFQ
      @techTFQ  2 роки тому +1

      Thank you Amaresh 🙏🏼
      Glad you liked it..

  • @palashmahata9782
    @palashmahata9782 10 місяців тому

    This was very very helpful to me. I'm currently learning MYSQL and this was the best explanation of windows functions I came across. I would love to see more videos on MYSQL!

  • @Jai-id7ik
    @Jai-id7ik 3 місяці тому +1

    Before attend any interview I will definitely check your this video.. Thanks

  • @singarampalaniappan1736
    @singarampalaniappan1736 2 роки тому +3

    Perfectly Explained !! No flaws

    • @techTFQ
      @techTFQ  2 роки тому

      Thank you palaniappan 🙏🏼
      Glad this helped..

  • @lilprotakeit
    @lilprotakeit Рік тому +8

    Amazing explanation. I was really pushing back on this part of SQL as i found it very difficult to read from books and blogs but you made it easy man. Thanks a lot !!

    • @techTFQ
      @techTFQ  Рік тому

      So glad to hear that ☺️☺️

    • @rasmitahembram4522
      @rasmitahembram4522 11 місяців тому

      Am I right to say that the problem statement - fetch top 3 employees in each department earning the max salary - can be solved using row_number() as well?

  • @ben-9200_
    @ben-9200_ Рік тому +1

    In 24 minutes you have explained to me window functions in a way better than spending 4 hours in Datacamp

  • @melaniekim9540
    @melaniekim9540 Рік тому

    Clear and concise demonstrations. Thank you for this!

  • @dhruvmadaan3276
    @dhruvmadaan3276 2 роки тому +5

    LOVE YOUR VIDEOS TFQ ! GREAT WAY OF EXPLAINING AND GREAT EXAMPLES ! THANK YOU AGAIN !
    WE DONT MIND IF THE VIDEOS ARE LONG, THEY ARE HIGH QUALITY !
    WE DONT CARE IF THERE IS BACKGROUND MUSIC OR NOT, THE WAY YOU EXPLAIN MATTERS THE MOST !

    • @techTFQ
      @techTFQ  2 роки тому

      Thank you Dhruv once again 🙏🏼
      Happy to know you liked them

  • @sumanmondal8836
    @sumanmondal8836 3 роки тому +22

    Please make another video for the remaining parts. Thank You!

    • @techTFQ
      @techTFQ  3 роки тому +4

      Thank you Suman.. will do it..

  • @rohitsurvase4190
    @rohitsurvase4190 4 місяці тому

    This is a masterclass for SQL window's function, great explanation!

  • @lebzgold7475
    @lebzgold7475 2 роки тому +1

    Amazing explanation! Was struggling with window functions - this was really clear! Many thanks to you Sir! :)

  • @shivkay
    @shivkay 2 роки тому +3

    You have the gift of teaching complex stuff in a very friendly and simple manner… best wishes for a great future

    • @techTFQ
      @techTFQ  2 роки тому

      Thank you Shiva 🙏🏼

  • @prabhaker9031
    @prabhaker9031 2 роки тому +3

    Couldn't be explained better. Great work.

    • @techTFQ
      @techTFQ  2 роки тому

      Thank you so much 🙏🏼
      Glad you liked it ☺️

  • @watitemjen2328
    @watitemjen2328 9 місяців тому

    Possibly the best tutorial on windows functions!

  • @user-dm6jg4qh2x
    @user-dm6jg4qh2x 9 місяців тому

    nunca escuche una explicación tan clara y concisa, muchísimas gracias y saludos desde Argentina

  • @christinesong5629
    @christinesong5629 2 роки тому +5

    Awesome! would love to see another video on other window functions. Please do another one!

    • @techTFQ
      @techTFQ  2 роки тому +2

      Thanks a lot 😃
      Will be doing another video on other window functions soon..

  • @sheebaparveen3630
    @sheebaparveen3630 3 роки тому +20

    Great. So proud of your intelligence. Your talent of teaching in such simple & understanding way is amazing 👍 Keep growing.

    • @techTFQ
      @techTFQ  3 роки тому +1

      Thank you dearest cheeb ❤️

  • @milesisterrible
    @milesisterrible Рік тому +1

    Absolutely excellent tutorial, could not have been better!

  • @pging8328
    @pging8328 Рік тому

    pedagogical value of vid is sublime. hands down man of the match.

  • @fathimafarahna2633
    @fathimafarahna2633 3 роки тому +6

    Awesome awesome 👌 You are simply the best, explaining, intention, dedication Perfection. Keep it up. God bless you. Amen🙏

    • @techTFQ
      @techTFQ  3 роки тому

      No words to thank you..
      still thank you to you for everything 🙏🏼❤️

  • @nabilraza456
    @nabilraza456 2 роки тому +3

    Such a helpful video to understand windowing functions. That was really helpful.

    • @techTFQ
      @techTFQ  2 роки тому

      Thank you 🙏🏼
      So glad u liked it 🙂

  • @niveditav691
    @niveditav691 Рік тому +1

    So well explained! Couldn't have been any better!

  • @ssk7690
    @ssk7690 Рік тому

    Thank you with all my heart, I read the documentations and couldn't understand it but you've made it quiet easy to understand!

  • @mohammadbajesaheb249
    @mohammadbajesaheb249 3 роки тому +3

    Bro simply your lecture is amazing

    • @techTFQ
      @techTFQ  3 роки тому

      Thanks a lot 🙏🏼 glad you liked it ☺️

  • @thedarkknight579
    @thedarkknight579 2 роки тому +3

    Best Video on Window Functions that I have watched till now💖💖💖💖

    • @techTFQ
      @techTFQ  2 роки тому +1

      Thank you so much 🙏🏼
      Glad this helped ..

    • @thedarkknight579
      @thedarkknight579 2 роки тому +1

      @@techTFQ I have recently cleared most of SQL rounds because of your video on Window Functions, I request you to continue the good work and plz do some UA-cam shorts on advanced level SQL questions, as they could be both interesting to watch as shorts and useful as brain teasers if someone is attending interviews.

    • @techTFQ
      @techTFQ  2 роки тому +1

      Awesome news bro.. am so glad my videos helped you to find a job.®️☺️👌👍
      As for shorts, really good idea, let me consider it..

  • @yairteshuva2495
    @yairteshuva2495 2 роки тому +1

    The clearest explanation in UA-cam.
    Great!

    • @techTFQ
      @techTFQ  2 роки тому

      Thank you 🙏🏼

  • @martchan6834
    @martchan6834 8 місяців тому

    Best demonstration so far!!! THANK YOUUU!!

  • @khushbooagarwal7491
    @khushbooagarwal7491 2 роки тому +4

    I was struggling so much with these window functions, thank you truly for this great video lecture. I've never ever commented to any video but this video right here deserves a respect 👏

    • @techTFQ
      @techTFQ  2 роки тому +1

      Thank you so so much Khushboo for this amazing feedback 🙏🏼
      I am so glad you took your time to comment on this video.. it feels great to know that this video has helped you understand the concept ☺️☺️

    • @khushbooagarwal7491
      @khushbooagarwal7491 2 роки тому +1

      @@techTFQ are you planning to make videos on machine learning too?

    • @techTFQ
      @techTFQ  2 роки тому +1

      Yes I plan to do it in the near future..
      in the next few weeks will focus on covering some data science concepts and then hopefully will cover machine learning too..

  • @atleticoluke
    @atleticoluke 2 роки тому +3

    Thank you so much! That's an amazing explanation!

    • @techTFQ
      @techTFQ  2 роки тому

      Your welcome Luiz 🙏🏼
      Glad this helped ..

  • @vidyasagarbv89
    @vidyasagarbv89 Рік тому +2

    I always searched for the syntax of window functions but after your explanation I dont find that necessary because you explained it very well.. 🙏

  • @omotolamusiliu3539
    @omotolamusiliu3539 2 роки тому +1

    This is the best and most comprehensible video I have seen on Windows Function since I have been practising SQL.

    • @techTFQ
      @techTFQ  2 роки тому

      Thank you Omotola 🙏🏼
      Glad this helped

  • @animoki9292
    @animoki9292 2 роки тому +3

    Enjoying every detail.. and as we know every detail matters ..and not many would present with all details.. u r amazing bro..God bless u..

    • @techTFQ
      @techTFQ  2 роки тому

      Thank you Ani for taking your time to appreciate my work 🙏🏼
      Truly appreciate the feedback 🙂

  • @livinspire7631
    @livinspire7631 Рік тому +2

    Thanks a ton in making these concepts so easy for us to understand . your teaching skills are just outstanding.Please let us know if you have a complete course.

    • @rasmitahembram4522
      @rasmitahembram4522 11 місяців тому

      Am I right to say that the problem statement - fetch top 3 employees in each department earning the max salary - can be solved using row_number() as well?

  • @TomMosquera01
    @TomMosquera01 Рік тому

    I am currently taking up a Data Analysis course via SQL and this was very helpful, since the instructor is having a hard time relaying her knowledge to us learners. Since this was step-by-step and used a basic example, this was more understandable.
    This topic on the course has a week's worth of lessons, yet I didn't learn as fast as the first 12 minutes of this video. Keep it up!

    • @techTFQ
      @techTFQ  Рік тому +1

      Super glad this helped and good luck with your learning

  • @sachinhipparge393
    @sachinhipparge393 Рік тому

    seriously i checked many youtube videos to learn sql whenever i start learning by seeing them i feel bore and dificult to learn,
    thanks to you sir your way of teaching and approach is very different that joins video also seen many times from other youtub pages but never got perfect when i seen your videos on join just in 20mnts whole join concept cleared im realy thanks a lot . even these window functions its just increased my excitement to evolve more on these.
    great work sir thank you.

  • @imsushantjain
    @imsushantjain 2 роки тому +4

    Really good, Thank You!. You should do more SQL tutorials, specially in a structured fashion and starting from basics.

    • @techTFQ
      @techTFQ  2 роки тому +1

      Thank you 🙏🏼
      Glad you’ve liked this video.
      Yeah, I might consider making a complete Sql tutorial playlist from scratch in the near future

  • @satyamsrivastava9034
    @satyamsrivastava9034 2 роки тому +3

    I can't tell you how helpful was this

    • @techTFQ
      @techTFQ  2 роки тому

      Thank you Satyam 🙏🏼
      Glad this helped ..

  • @jeffrinvite1107
    @jeffrinvite1107 Рік тому

    This is the best video I've ever came across for the window function. Thank you!!!

  • @ashutoshsharmaxi
    @ashutoshsharmaxi Рік тому

    thank you sooooo much for this video.... I have commented on only 8-10 videos in my whole youtube life and you are one of them... superb explanation...

  • @bhanureddy8780
    @bhanureddy8780 2 роки тому +3

    damn Bloody good. Just loved the explanation and the content. you did save a ton of time for me. wish you all the best.

    • @techTFQ
      @techTFQ  2 роки тому

      Thanks a lot for your kind words ☺️☺️
      So glad it helped 🙏🏼

  • @sandeepkhawas3367
    @sandeepkhawas3367 2 роки тому +3

    Dear brother...the way you are explaining the things is very easy to understand.. day by day i m increasing my knowledge on SQL...thanks for your all efforts and i wish you all the best!

  • @shahrukhtheanalyst
    @shahrukhtheanalyst Рік тому

    Best explaination!! I have watched and read 1000s of videos/articles but was unable to grasp window function concepts. This Video really gave a detailed breakdown of how Window Functions work as well as their use cases. Love from Pakistan

  • @troyshen9421
    @troyshen9421 2 роки тому +1

    Thank you! Very helpful for someone who just decided to pick up window function.

    • @techTFQ
      @techTFQ  2 роки тому

      Glad it helped

  • @SKumar-fl1vx
    @SKumar-fl1vx 3 роки тому +3

    well taught and easily understood could you do video on other window functions and stress more on use cases

    • @techTFQ
      @techTFQ  3 роки тому

      Thanks a lot for your kind words 🙏🏼
      Sure will consider your feedback ..

  • @paulgideons6960
    @paulgideons6960 Рік тому +1

    this one video explains everything you need to know about window functions in SQL!!

  • @mad24960
    @mad24960 2 роки тому +1

    Not a ton of VERY clear advanced SQL Windows functions out there - easy to understand and really clear! Thank-you for the work

    • @techTFQ
      @techTFQ  2 роки тому

      Glad you liked it Matthew

  • @troyporter3825
    @troyporter3825 3 місяці тому

    Cant believe i havent been using these functions!!!..Thank you..this was great!

  • @naderbazyari2
    @naderbazyari2 Рік тому

    This video is awesome!! Free education and practical. Many thanks man. I am preparing for an interview. Thank you.

  • @vuphan2956
    @vuphan2956 Рік тому +1

    To be honest, you tech better than some of professors in college. I will watch every of your videos. Thank you.

  • @kayceeDis
    @kayceeDis Місяць тому

    Thank you! you just removed all of my troubles! you explained it very clearly and it was super easy to follow.

  • @iUmerFarooq
    @iUmerFarooq 12 днів тому

    Now everything about sql windows function is cleared.
    Thank you very much 😉💪🔥
    Love from Peshawar, Pakistan 💚

  • @aliciachen9750
    @aliciachen9750 2 роки тому +1

    SUPER clear. much better than some of the other tutorials that I saw out there. Thank you very much!

    • @techTFQ
      @techTFQ  2 роки тому

      Thank you Alicia :)

  • @priyajangid5437
    @priyajangid5437 Рік тому +1

    Best Explanation for Windows function till the time, thank you so much for showing in the PostgreSQL, I am so happy that I understood it very well!!!!!!!!!!! Thank you TECHTFQ

    • @techTFQ
      @techTFQ  Рік тому

      Your welcome Priya and glad this helped 🙏🏼

  • @myyouaccounttube1024
    @myyouaccounttube1024 5 місяців тому

    SQL is knowledge, but to know how to teach it in such a beautiful and beginner friendly way, is an art! Bravo for this video. Not only I subscribed to your channel I'll present it to everyone who needs a good
    course in SQL. 👏👏👏👏👏👏

  • @muhammadalibhatti538
    @muhammadalibhatti538 3 місяці тому

    This is the best video for explaining the Window functions in SQL, I really do not know about them before watching this video.
    Well explained by you.

  • @MsShenjie
    @MsShenjie 2 роки тому +1

    Explained the clearest I've see so far. Thank you!

    • @techTFQ
      @techTFQ  2 роки тому

      Glad you liked it ☺️

  • @bapiloya
    @bapiloya Рік тому

    Clear and concise , thank you very much!

  • @amit-jx5lh
    @amit-jx5lh 4 місяці тому

    These people have literally made youtube platform a university, where you can learn anything for free. ❤

  • @ashwinishinde4640
    @ashwinishinde4640 Рік тому

    Explained perfectly. Thank you

  • @yinuochen9616
    @yinuochen9616 2 роки тому

    amazing logic and clarity!love!

  • @eegernades
    @eegernades Рік тому

    sqlzoo's page about this is just returning system errors. So had to search elsewhere to learn and this video shows it in a clear and informative manner. Thanks tremendously for this gem of a video to explain these concepts.

  • @Vedanvita
    @Vedanvita 3 місяці тому

    Hello, Its an excellent channel for SQL. I was asked the same questions in my interview and I watched this video just before it. Love the content. Thank you

  • @ruchikapattjoshi4223
    @ruchikapattjoshi4223 Рік тому

    This is really amazing!! Best examples and demonstration and clear and concise examples, easy to understand and grasp window functions concepts. Thank you for the wonderful work😃

  • @samsonkiflom5954
    @samsonkiflom5954 Рік тому

    you got my sub after watching the first 6 mins and 23 seconds :) lucid explanation. nice job!

  • @rohitahuja999
    @rohitahuja999 Рік тому

    best explaination of window functions in sql with examples

  • @mohdfaisal4725
    @mohdfaisal4725 Рік тому

    Just have no words to say thanks, you are just inexplicable, woahh amazing

  • @coolmedico4887
    @coolmedico4887 7 місяців тому +1

    You saved my hours of classes to understand such complex concepts in such a short span of time... Thanks bhai...

    • @techTFQ
      @techTFQ  6 місяців тому

      Welcome:)

  • @Digital_Sansaar
    @Digital_Sansaar Рік тому

    Great video having extension explanations of window functions

  • @sheikhsaqlain3931
    @sheikhsaqlain3931 Місяць тому

    You are an amazing tutor, My first appreciation commend to someone

  • @nandhukrishna
    @nandhukrishna 3 місяці тому

    you are the best ,explains everything clearly .I am so thankful 🙏

  • @dj4583
    @dj4583 9 місяців тому

    It was really helpful video i went through it just 1 day before my interview day and I was able to understand the concept .