SQL Term and Example?

Nebraska_God · #1 (**permalink**) 12-02-09, 23:32

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

r937 · #2 (**permalink**) 12-03-09, 00:06

pivot query

Nebraska_God · #3 (**permalink**) 12-03-09, 00:43

Thank you!

Internet Services

Web Development

Digital Marketing

Consumer Tech