Abstract
It is probably extremely few developers that haven’t been asked to create a Top-N report. The questions by the business that can be classified as a Top-N question are legion. Which of our products sell the most? Which user profiles create the most tweets? And so on. Top-N reports come in three flavors all demonstrated in this chapter: top rows, Olympic rule, and top values.
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
© 2020 Kim Berg Hansen
About this chapter
Cite this chapter
Berg Hansen, K. (2020). Answering Top-N Questions. In: Practical Oracle SQL. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-5617-6_12
Download citation
DOI: https://doi.org/10.1007/978-1-4842-5617-6_12
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-5616-9
Online ISBN: 978-1-4842-5617-6
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books