Home » SQL & PL/SQL » SQL & PL/SQL » Pivot Query
Pivot Query [message #259739] Thu, 16 August 2007 06:48 Go to next message
sandeepknair
Messages: 1
Registered: July 2005
Location: UK
Junior Member
Hi

I have a table with two columns and values as follows;
COl1 COl2
A 10
B 20
C 30
D 40

I would like the result set to display

A B C D
10 20 30 40

Could you please provide a query for the same. Did go through all the cross tab examples but could not retrieve the same way as i want.
Re: Pivot Query [message #259743 is a reply to message #259739] Thu, 16 August 2007 06:50 Go to previous message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You don't search very well.
Retry.
Closed.
./fa/448/0/
Regards
Michel
Previous Topic: CLOB DATA TYPE PROBLEM
Next Topic: Conditional Compilation?
Goto Forum:
  


Current Time: Wed Dec 07 16:30:24 CST 2016

Total time taken to generate the page: 0.12172 seconds