In this post, I am sharing the demonstration on the new LEAD() function which is introduced by SQL Server 2012. Generally, we are using Self Join to perform row-level analysis by comparing Next and Previous rows. SQL Server 2012 has a LEAD() function, is used for accessing data from the Next Row in the same … Continue reading SQL Server 2012: Introduced LEAD function, the best alternative of Self Join to compare Next Row