CHAPTER

24

Business Intelligence and Transact-SQL

In This Chapter

•   Window Construct

•   Extensions of GROUP BY

•   OLAP Query Functions

•   Standard and Nonstandard Analytic Functions

Have you ever tried to write a Transact-SQL query that computes the percentage change in values between the last two quarters? Or one that implements cumulative sums or sliding aggregations? If you have ever tried, you know how difficult these tasks are. Today, you don’t have to implement them anymore. The SQL standard has adopted a set of online analytical processing (OLAP) functions that enable you to easily perform these calculations and many others that used to be very complex for implementation. This part of the SQL standard is called SQL/OLAP. Therefore, ...

Get Microsoft SQL Server 2019: A Beginner's Guide, Seventh Edition, 7th Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.