Lead and Lag function in SQL Server 2012

added by Sandeep Mittal
5/16/2013 2:41:49 PM

0 Kicks, 50 Views

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