Home » Other » Client Tools » ROWS to COLUMNS
ROWS to COLUMNS [message #25932] Tue, 27 May 2003 13:14 Go to next message
Karri
Messages: 33
Registered: May 2001
Member
I have information on rows, but I want it
in to columns. How can I do it?

Example:
Month Day Bonus
Jan 31 100
Feb 28 0
Mar 31 300
Apr 30 50

and s.o.
I want to see only column Month, like this:
Jan Feb Mar Apr

Or like this:
100 0 300 50

This is not a good example because I can
do a WHERE-caluse which make it like I want.
But how can I do it whitout WHERE-clause?
Is it possible or not?

Thanks, Karri
Re: ROWS to COLUMNS [message #25933 is a reply to message #25932] Tue, 27 May 2003 13:34 Go to previous messageGo to next message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
This is called a "pivot" query. Here is an example of how to turn rows into columns:

Re: ROWS to COLUMNS [message #25946 is a reply to message #25933] Wed, 28 May 2003 03:59 Go to previous message
Karri
Messages: 33
Registered: May 2001
Member
Thanks Todd!
Previous Topic: Most Most Most urgent help need about temporary table and matrix reps
Next Topic: Retrieve nclob data
Goto Forum:
  


Current Time: Fri Mar 29 03:46:02 CDT 2024