View Single Post
  #1   Report Post  
Frank
 
Posts: n/a
Default How to aggregate values in a database

I have values in 3 columns that I want this values

Col1 Col2 Col3
1 2 3
1 2 5
3 4 7
3 4 7
3 4 9
5 6 5

to be aggregated in the folowing table:

Col1 FreqCol2 FreqCol3
1 2(2) 3(1)
1 5(1)
3 4(3) 7(2)
3 9(1)
5 6(1) 5(1)

Any suggestion on solution to this issue?

Thanks,
Frank