Wednesday, October 14, 2015

Lead and Lag functions in SQL Server 2012

Have you ever been in a situation where you needed to write a query that needed to do comparisons or access data from the subsequent rows along with the data from the current row? This article discusses different ways to write these types of queries and more specifically examines LEAD and LAG analytics functions, which were introduced with SQL Server 2012, and helps you understand how leveraging these functions can aid you in such situations. For more information click here.

No comments:

Post a Comment