Home » SQL & PL/SQL » SQL & PL/SQL » How to multiple columns into single row
How to multiple columns into single row [message #305048] Fri, 07 March 2008 15:58 Go to next message
vamsik
Messages: 15
Registered: February 2007
Junior Member
Hi all,

I have the data like this.


master ID prod charge
--------- ------ --------
aaaa bb 100
aaaa cc 200
aaaa dd 300
aaaa ee 400

Please help me out to write the query to get the data like this:

master ID bb cc dd ee
--------- --- --- --- ----
aaaa 100 200 300 400


Thanks in Advance,
vamsi.

Re: How to multiple columns into single row [message #305053 is a reply to message #305048] Fri, 07 March 2008 19:00 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
You can search the site for "pivot" and/or check out How does one code a matrix/crosstab/pivot report in SQL?.
Previous Topic: DEGREE parameter NOT working while gathering INDEX STATS
Next Topic: Query help
Goto Forum:
  


Current Time: Fri Dec 02 13:46:31 CST 2016

Total time taken to generate the page: 0.11776 seconds