[SQL] Lead & Lag Window Function

Published: 16 July 2018
on channel: ProfessorPitch

1,566

This tutorial will walk you through SQL server on using the Lead or Lag function. Adding this to your SQL select statement, it can output you the previous/next data value in the partition. This is very useful when wanting to see a particular data value a customer had prior to making a change.

Github Script:
https://github.com/ProfessorPitch/Pro...

Lag:
https://docs.microsoft.com/en-us/sql/...

Lead:
https://docs.microsoft.com/en-us/sql/...

On this page of the site you can watch the video online [SQL] Lead & Lag Window Function with a duration of hours minute second in good quality, which was uploaded by the user ProfessorPitch 16 July 2018, share the link with friends and acquaintances, this video has already been watched 1,566 times on youtube and it was liked by 15 viewers. Enjoy your viewing!

2,280