我有一个名为ABC的表,该表具有C1,C2,C3。我想找出每个不同值的时间数量,并将其存储在2维数组中。它应该看起来像:
{
value1, count1,
value2, count2,
value3, count3,
}
select col1,count(col1) from abc group by col1
union all
select col2,count(col2) from abc group by col2
union all
select col3,count(col3) from abc group by col3