• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part V: Appendix > Creating a Crosstab Query with SQL TRANSFORM

Creating a Crosstab Query with SQL TRANSFORM

A crosstab query is a great way to present a lot of data in a consistent and easy-to-read format. These queries summarize data by categories, generally using an aggregate function for the summary calculations. The general rule of thumb is that the query must have at least one column heading and one summary column.

Crosstab queries are produced by SQL’s TRANSFORM statement, which takes the form


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint