Advertisement

Chapter 7: Windowing Functions

by Wayne Sheffield
  • Jason Brimhall
  • Jonathan Gennick
  • Wayne Sheffield

Abstract

SQL Server is designed to work best on sets of data. By definition, sets of data are unordered; it is not until the query’s ORDER BY clause that the final results of the query become ordered. Windowing functions allow your query to look at a subset of the rows being returned by your query before applying the function to just those rows. In doing so, the functions allow you to specify an order for your unordered subset of data so as to evaluate that data in a particular order. This is performed before the final result is ordered (and in addition to it). This allows for processes that previously required self-joins, the use of inefficient inequality operators, or non-set-based row-by-row (iterative) processing to use more efficient set-based processing.

Keywords

Count Function Sensor Reading Location Order Aggregate Function 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

© Jason Brimhall, Jonathan Gennick, and Wayne Sheffield 2015

Authors and Affiliations

  • Jason Brimhall
    • 1
  • Jonathan Gennick
    • 1
  • Wayne Sheffield
    • 1
  1. 1.UTUS

Personalised recommendations