Home » SQL & PL/SQL » SQL & PL/SQL » Help me
Help me [message #384510] Wed, 04 February 2009 02:51 Go to next message
icmohsin
Messages: 12
Registered: January 2009
Location: Mumbai
Junior Member
I have a table suppose asd

number name
1 a
2 b
1 aa
2 bb
1 aaa
3 c
4 d

I want output like this

number name name1 name2
1 a aa aaa
2 b bb
3 c
4 d

Please give me query for this
Re: Help me [message #384513 is a reply to message #384510] Wed, 04 February 2009 02:55 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Search the forum for "PIVOT"
Re: Help me [message #384514 is a reply to message #384510] Wed, 04 February 2009 02:58 Go to previous messageGo to next message
icmohsin
Messages: 12
Registered: January 2009
Location: Mumbai
Junior Member
I am using Oracle 9i and "PIVOT" not work in 9i
Re: Help me [message #384515 is a reply to message #384514] Wed, 04 February 2009 03:00 Go to previous message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
But the things you will find when you search the forum for it will work in 9i.
Previous Topic: how to do this query pls? (merged)
Next Topic: Compare Two Tables and generate the differences in the third (merged 3 + really old one)
Goto Forum:
  


Current Time: Sun Dec 04 21:03:45 CST 2016

Total time taken to generate the page: 0.09635 seconds