CHAPTER |
|
24 |
Business Intelligence and Transact-SQL |
In This Chapter
• 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.