MySQL Multi-Aggregated Rows in Crosstab Queries

"MySQL's crosstabs contain aggregate functions on two or more fields, presented in a tabular format. In a multi-aggregate crosstab query, two different functions can be applied to the same field or the same function can be applied to multiple fields on the same (row or column) axis. Rob Gravelle shows you how to apply two different functions to the same field in order to create grouping levels in the row axis.

"Today's topic of discussion is crosstabs, which contain multiple aggregate functions in the row axis of a tabular resultset. Recall from the the All About the Crosstab Query article that an aggregate function is one that summarizes a group of related data in some way. Examples of aggregate functions include COUNT, SUM, AVG, MIN, and MAX. In a multi-aggregate crosstab query, two different functions can be applied to the same field or the same function can be applied to two or more fields. Today we'll create a query that applies two different functions to the same field in order to create grouping levels in the row axis."

Complete Story

Related Stories:

• Linux is now Oracle's low-end offering(Feb 21, 2010)
• Installing Cherokee With PHP5 And MySQL Support On Ubuntu 9.10(Feb 17, 2010)
• What happens to Sun's open-source software now?(Feb 16, 2010)
• DRBD and MySQL - Heartbeat Setup(Feb 12, 2010)
• MySQL Founder Monty Widenius On What to Expect Next(Feb 05, 2010)
• The Fight to Save MySQL: Interview with Monty Widenius(Jan 27, 2010)