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: 64729
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: Fri Apr 28 03:25:17 CDT 2017

Total time taken to generate the page: 0.15989 seconds