Sinopsis
Part I. Core SQL
1. Correlating Inline Views
2. Pitfalls of Set Operations
3. Divide and Conquer with Subquery Factoring
4. Tree Calculations with Recursion
5. Functions Defined Within SQL
6. Iterative Calculations with Multidimensional Data
7. Unpivoting Columns to Rows
8. Pivoting Rows to Columns
9. Splitting Delimited Text
10. Creating Delimited Text
Part II. Analytic Functions
11. Analytic Partitions, Ordering and Windows
12. Answering Top-N Questions
13. Ordered Subsets with Rolling Sums
14. Analyzing Activity Logs with Lead
15. Forecasting with Linear Regression
16. Rolling Sums to Forecast Reaching Minimums
Part III. Row Pattern Matching
17. Up and Down Patterns
18. Grouping Data Through Patterns
19. Merging Date Ranges
20. Finding Abnormal Peaks
21. Bin Fitting
22. Counting Children in Trees
"Sinopsis" puede pertenecer a otra edición de este libro.