LAST VALUE function in SQL Server

แชร์
ฝัง
  • เผยแพร่เมื่อ 30 พ.ย. 2024

ความคิดเห็น • 23

  • @Bajtjr
    @Bajtjr ปีที่แล้ว

    I was initially very confused about why this function is returning strange results but you explained it perfectly. Thank you very much.

  • @paulots5309
    @paulots5309 9 ปีที่แล้ว +9

    Everyday around the same time I come to check if there is another new SQL video, and everyday I get happy about this :)

  • @raqibulAlam-su3jo
    @raqibulAlam-su3jo 9 ปีที่แล้ว +2

    I enjoy your tutorial just like a Box office hit Hollywood movie.Thanks a billion.

  • @krzysztofs8535
    @krzysztofs8535 7 ปีที่แล้ว +1

    Venkat rules as always! Thank you Venkat for educating community and have a great day and life ! We are very thankful !

  • @ymtan
    @ymtan 9 ปีที่แล้ว +6

    I would like to express my sincere gratitude and appreciation for your dedication, selfless, passionate, and hard work. We cannot thank you enough who worked tirelessly behind the scenes contributing to the .NET community through your amazing and superb tutorial videos.

  • @vaibhavpatharkar6794
    @vaibhavpatharkar6794 ปีที่แล้ว

    Thank you sir. Your explanation is very clear and nice .

  • @girijesh-mca
    @girijesh-mca 9 ปีที่แล้ว +4

    Great Sir !!! again you have recorded a very helpful video for us thank you so much sir for doing this. can you please upload a video for Inversion of control (IOC) and Dependency Injection (DI) for MVC this is very common interview question we are facing. it would be great help to us. I watched almost your all videos and I found your explanation is very very great and clear no other one can be "Kudvenkat" in this world...great salute sir.

  • @vaibhavpatharkar6794
    @vaibhavpatharkar6794 ปีที่แล้ว

    Pp complete the SQL series of videos. No one teaches better than you . Pl accept my salute

  • @suyash7450
    @suyash7450 ปีที่แล้ว

    I was stuck at this thanks for clearing this for me

  • @aimanazeem9143
    @aimanazeem9143 4 ปีที่แล้ว

    Thank you.. This video is really helpful my issue is solved atlast. But I add top 1 also before last_value because I was using it in subquery and it was returning many values.. Again Thanks for this video..!

  • @theshiva1244
    @theshiva1244 9 ปีที่แล้ว

    Thanks for sharing the new features. SQL paging 2012 OFFSET using order by fetch and also more sorting. i want detailed description.
    Thanku

  • @muhammadrehbarsheikh8498
    @muhammadrehbarsheikh8498 9 ปีที่แล้ว +1

    Thanks sir!!

  • @iamKamzar
    @iamKamzar 5 ปีที่แล้ว

    what if i wanna get the current value and all the previous values that were stored for a specific ID?

  • @qudsif
    @qudsif 3 ปีที่แล้ว

    Is the default range of rows same for LEAD and LAST_VALUE same?

  • @shanmugavelsugumar3529
    @shanmugavelsugumar3529 5 ปีที่แล้ว +2

    I think last name is same as using first value() over(order by salary desc)

    • @vipinnair555
      @vipinnair555 4 ปีที่แล้ว

      Technically speaking! Yes

  • @jhansibode554
    @jhansibode554 5 ปีที่แล้ว

    how to replace with previous record value with empty record ,can you pls help me with the answer

  • @SandeepSharma-hv9pr
    @SandeepSharma-hv9pr 7 ปีที่แล้ว

    sir can you tell us how to write this query in netbeans when i try its not work

  • @sumathi3782
    @sumathi3782 7 ปีที่แล้ว

    sir my question is write a query to get the who registered to last day of previous day?

    • @anuragsharma238
      @anuragsharma238 4 ปีที่แล้ว

      Take a last_value( ) over the lag function with one day

  • @dpdhamal
    @dpdhamal 4 ปีที่แล้ว

    Thank you is not enough for your selfless act

  • @AK__99
    @AK__99 ปีที่แล้ว

    Am I not the only one who came to see this after 8 years?

  • @rohitsethi5696
    @rohitsethi5696 4 ปีที่แล้ว

    NEXT VALUE FOR