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: 65085
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: Mon Jul 24 04:23:32 CDT 2017

Total time taken to generate the page: 0.11153 seconds