I have a table "HIS_RAW" with fields -TIMESTAMP,POINTID,VALUE .This table has historical average value stored for different datapoints. Iwant to query the table to get value of different pointid say {m1,m2,m3,m4} in the below format TIMESTAMP -VALUE OF POINTID1- VALUE OF POINTID2 ---VALUE OF POINTID3 If i use group on pointid,I get data in format : pointid1 timestamp value timestamp value timestamp value pointid2 timestamp value timestamp value