MySQL CASE Statements in Multi-Aggregated Crosstab Columns
Posted
on Internet.com
See other posts from Internet.com
Published on Tue, 23 Feb 2010 05:00:00 +010
Indexed on
2010/03/07
23:12 UTC
Read the original article
Hit count: 313
Filed under:
Inserting additional columns to a crosstab query is less straightforward than adding row data, because SQL naturally groups data by rows. Moreover, the efficacy of the CASE statement within an aggregate function decreases in direct proportion to the complexity of the criteria. Read on to learn more...
© Internet.com or respective owner