Looking Through the Window

  • Kathi Kellenberger
  • Clayton Groom
  • Ed Pollack


SQL Server is a powerful database platform with a versatile query language called T-SQL. The most exciting T-SQL enhancement over the years, in my opinion, is the window functions. Window functions enable you to solve query problems in new, easier ways and with better performance most of the time over traditional techniques. They are a great tool for analytics. You may hear these called “windowing” or “windowed” functions as well. The three terms are synonymous when talking about this feature.

Copyright information

© Kathi Kellenberger, Clayton Groom, and Ed Pollack 2019

Authors and Affiliations

  • Kathi Kellenberger
    • 1
  • Clayton Groom
    • 2
  • Ed Pollack
    • 3
  1. 1.EdwardsvilleUSA
  2. 2.SmithtonUSA
  3. 3.AlbanyUSA

Personalised recommendations