Skip to Main Content
Beginning T-SQL
book

Beginning T-SQL

by Kathi Kellenberger, Scott Shaw
August 2014
Beginner content levelBeginner
496 pages
12h 26m
English
Apress
Content preview from Beginning T-SQL

CHAPTER 8

image

Discovering Windowing Functions

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 ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

T-SQL Fundamentals, 4th Edition

T-SQL Fundamentals, 4th Edition

Itzik Ben-Gan
Learning SQL

Learning SQL

Ben Forta

Publisher Resources

ISBN: 9781484200469Purchase book