In this chapter, you’ll learn how to perform the following tasks:
Use analytic functions to perform complex calculations
Perform inter-row calculations using the
UNPIVOTclauses, which are useful for finding trends in data
Perform top-N queries to return the top or bottom N rows from ...