view query output in horizontal format

[RamyaKarri]

i get the output of the query as

Jan 0.1
Feb 1
MAR 2
..

I Want to view data in the following format

Jan Feb Mar
0.1 1 2

My query is :


SELECT Allocation.mont h, Allocation.Allo cationValue
FROM Allocation
WHERE Allocation.year =2007 and Allocation.Proj ectName='65nm' and Allocation.SubP rojectName='65n m' and Allocation.Func tion='Device Eng'
;

Can any please help me?

Thanks in advance,

Ramya

[ronverdonk]

You already got your answer in a duplicate thread HERE

Ronald