Chapter 21 - Aggregation Function

“Teradata climbed Aggregate Mountain and delivered a better way to Sum It.”

- Tera-Tom Coffing

Quiz – You calculate the Answer Set in your own Mind

images

What would the result set be from the above query? The next slide shows answers!

Answer – You calculate the Answer Set in your own Mind

images

Here are your answers!

The 3 Rules of Aggregation

images

There are Five Aggregates

 

There are FIVE AGGREGATES which are the following: ...

Get Tera-Tom's 1000 Page e-Book on Teradata Architecture and SQL, 2nd Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.