Home » SQL & PL/SQL » SQL & PL/SQL » Converting to columns
Converting to columns [message #223923] Mon, 12 March 2007 04:58 Go to next message
aankha
Messages: 8
Registered: January 2007
Location: Nepal
Junior Member
I have data in each row that needs to be transposed into columns. Eg.. I have the records
Date Time Entity Value
2007-7-11 11:00 a 56
2007-7-11 11:00 b 51
2007-7-11 11:00 c 6
2007-7-11 11:00 d 50
2007-7-11 12:00 a 23
2007-7-11 12:00 b 12
2007-7-11 12:00 c 11
2007-7-11 12:00 d 67

I need it in the form

Date Time a b c d
2007-7-11 11:00 56 51 6 50
2007-7-11 12:00 23 12 11 67


Is there an easy way to do this?
Re: Converting to columns [message #223938 is a reply to message #223923] Mon, 12 March 2007 05:50 Go to previous message
bonker
Messages: 402
Registered: July 2005
Senior Member
search this forum for pivot
Previous Topic: How to get record number of a table without using ROWNUM?
Next Topic: Query to calculate working hours
Goto Forum:
  


Current Time: Sat Dec 03 01:27:14 CST 2016

Total time taken to generate the page: 0.08071 seconds