Calculating Delta Values in SQL | The Difference Between Two Rows | Essential Skills

Поделиться
HTML-код
  • Опубликовано: 6 сен 2024
  • In this SQL tutorial I cover a key SQL skill that will regularly crop up in challenges or interviews: calculating the delta or difference between values in previous rows.
    I provide the script for creating our practice table and values, if you want to follow along. I'll then go through a solution using the LAG() window function, FORMAT() function and Temp Tables.
    Enjoy!
    🤝 Connect with me on LinkedIn:
    / ja376
    🤝 View my Website:
    www.matadorsof...
    🖥📝 I also have a great value 2 hour data career consultation service to get you on the right track. Covering resumes, ATS, data technology, soft skills, roadmaps and a take home document pack at great value. Check out the Fiverr gig below:
    www.fiverr.com...

Комментарии • 2

  • @AliMalik-yt5ex
    @AliMalik-yt5ex Год назад

    Hey, really good stuff. I found the music to be somewhat distracting. I think the video would do fine just without it, just a suggestion.

    • @MatadorSoftware
      @MatadorSoftware  Год назад +1

      Thanks for the comment Ali, I appreciate it and will certainly take the feedback on board!