Abstract
In this chapter, we use the ranking window functions to perform some analysis on the power plant database. There are only four functions, but we will check out performance as usual and also create a few Microsoft Excel pivot tables and graphs to take our analysis a step further.
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
© 2023 The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature
About this chapter
Cite this chapter
Bobak, A. (2023). Plant Use Case: Ranking Functions. In: SQL Server Analytical Toolkit. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-8667-8_9
Download citation
DOI: https://doi.org/10.1007/978-1-4842-8667-8_9
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-8666-1
Online ISBN: 978-1-4842-8667-8
eBook Packages: Professional and Applied ComputingApress Access BooksProfessional and Applied Computing (R0)