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.