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...
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.
Thanks for the comment Ali, I appreciate it and will certainly take the feedback on board!