How to display one column values to multiple column values?

[kishore Roul]

input is like
Type,Financial_ yr,Month,Amount
T1 ,2010 ,April,1000
T1 ,2010 ,May ,2000
T1 ,2010 ,June ,3000
T2 ,2011 ,May ,1500
T2 ,2011 ,July ,3500
T2 ,2011 ,Aug ,4000
My output wiil be like
Type,Financial_ yr,M1 ,M2 ,M3 ,Total_amount
T1 ,2010 ,1000 ,2000,3000,6000
T2 ,2011 ,1500 ,3500,4000,9000

[Rabbit]

You could use a pivot if oracle supports that. Otherwise you'll have to use a bunch of case statements.

[debasisdas]

You need to read the following article for details.

article.

[amitpatel66]

Thats called pivot. Which version of database are you using?