Skip to Main Content
T-SQL Window Functions: For data analysis and beyond, 2nd Edition
book

T-SQL Window Functions: For data analysis and beyond, 2nd Edition

by Itzik Ben-Gan
November 2019
Intermediate to advanced content levelIntermediate to advanced
352 pages
12h 27m
English
Microsoft Press
Content preview from T-SQL Window Functions: For data analysis and beyond, 2nd Edition

CHAPTER 1

SQL Windowing

Window functions can help solve a wide variety of querying tasks by helping you express set calculations more easily, intuitively, and efficiently than ever before. Window functions are functions applied to sets of rows defined by a clause called OVER. They are used mainly for analytical purposes, allowing you to calculate running totals, calculate moving averages, identify gaps and islands in your data, handle intervals, and perform many other computations. These functions are based on an amazingly profound concept in the ISO/IEC SQL standard—the concept of windowing. The idea behind windowing is to allow you to apply various calculations to a set, or window, of rows and return a single value.

Window functions have evolved ...

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

SQL for Data Analysis

SQL for Data Analysis

Cathy Tanimura

Publisher Resources

ISBN: 9780135861554