Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2006
    Posts
    22

    Question Unanswered: SQL Term and Example?

    What is the term for a query that returns a two dimensional report? The values would be the sum of some field. I added an example below. I'm assuming once I know the term I can search for an example but if you have one handy I would appreciate it.

    Month test1 test2 test3 total
    Jan 5 10 6 21
    Feb 1 0 5 6
    Mar 9 12 0 21

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    pivot query
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Jun 2006
    Posts
    22
    Thank you!

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •