Abstract
The windowing functions, sometimes called window or windowed functions, are the most exciting features added to T-SQL over the past several versions. Starting with SQL Server 2005, the window functions, which have nothing to do with the Windows operating system, enable T-SQL developers to solve complex queries in new and innovative ways. Window functions perform calculations over a “window” or set of rows. They allow the developer to solve problems in easier and frequently better performing ways. This chapter will explain the ranking and window aggregate functions added with SQL Server 2005 and the many enhancements and new analytic functions that are part of SQL Server 2012.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2021 Kathi Kellenberger, Lee Everest
About this chapter
Cite this chapter
Kellenberger, K., Everest, L. (2021). Discovering Windowing Functions. In: Beginning T-SQL. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-6606-9_8
Download citation
DOI: https://doi.org/10.1007/978-1-4842-6606-9_8
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-6605-2
Online ISBN: 978-1-4842-6606-9
eBook Packages: Professional and Applied ComputingApress Access BooksProfessional and Applied Computing (R0)