Advertisement

Taking a Peek at Another Row

  • Kathi Kellenberger
  • Clayton Groom
Chapter

Abstract

Along with accumulating window aggregates, Microsoft added eight new window functions with SQL Server 2012. Four of the functions, which I'll call offset functions in this book, are my favorite T-SQL functions, and they are LAG, LEAD, FIRST_VALUE, and LAST_VALUE. These functions let you include any columns from other rows in your results without a self-join and with fantastic performance.

Keywords

Window Function Execution Plan Support Framing Query Window Lead Function 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Copyright information

© Kathi Kellenberger with Clayton Groom 2015

Authors and Affiliations

  • Kathi Kellenberger
    • 1
  • Clayton Groom
    • 1
  1. 1.ILUnited States

Personalised recommendations