No credit card required
“Teradata climbed the Aggregate Mountain and delivered a better way to Sum It.”
Table of Contents Chapter 17 – Aggregation Function
– Quiz – You calculate the Answer Set in your own Mind
– Answer – You calculate the Answer Set in your own Mind
– The 3 Rules of Aggregation
– There are Five Aggregates
– Quiz – How many rows come back?
– Troubleshooting Aggregates
– GROUP BY when Aggregates and Normal Columns Mix
– GROUP BY Delivers one row per Group
– GROUP BY Dept_No or GROUP BY 1 the same thing
– Limiting Rows and Improving Performance with WHERE
– WHERE Clause in Aggregation limits unneeded Calculations
– Keyword HAVING tests Aggregates after they are Totaled
– Keyword HAVING is like an Extra ...