Home » SQL & PL/SQL » SQL & PL/SQL » Need a small help in query
Need a small help in query [message #297485] Fri, 01 February 2008 00:32 Go to next message
Messages: 6
Registered: August 2007
Location: Hyderabad
Junior Member

1) i have a table like this

class subject
1 hindi
1 telugu
2 maths
2 english
............and so on

i need to write the query output like this

1 hindi|telugu
2 maths|english
... and so on

Re: Need a small help in query [message #297486 is a reply to message #297485] Fri, 01 February 2008 00:33 Go to previous message
Michel Cadot
Messages: 64618
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Search for pivot.
Question asked about once per week.

Previous Topic: Weird behaviour of Rownum
Next Topic: Compare Rcords
Goto Forum:

Current Time: Tue Mar 28 20:18:40 CDT 2017

Total time taken to generate the page: 0.61079 seconds