how about this? i want to count all unique comid in table inout. so i try this,


select count(*), comid from inout group by comid
which gives me,

cnt comid
1    01
2    02
1    04

i want it to appear like,

01 02 04
1   2  1 

how will i be able to do that? is there any way i can make the column comid as field names?

pls help. TIA.