SQL SERVER – Introduction to LEAD and LAG – Analytic Functions Introduced in SQL Server 2012

(Pinal Dave) SQL Server 2012 introduces new analytical function LEAD() and LAG(). This functions accesses data from a subsequent row (for lead) and previous row (for lag) in the same result set without the use of a self-join.

Read More - Register for Free Membership