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.