how many times

[mharoon99]

simple for many of you guys...
Question :I have a table with 3 columns with datatype number. the data for each column is between 1 - 30.(300K records)

Required Solution: A) get a result that would provide how many times a specific # in all the columns are there... eg # 5 shows up 4 times in the below "example data".
B) occurance of a # in specific column eg # 3 -- 2 times, # 2 -- 2 times etc.

Any help would be greatly appreciated

Table A
-------------
wn1 number(2) NN
wn2 number (2)NN
wn3 number (2)NN

TABLE A DATA
WN1 WN2 WN3
--- --- ---
2 5 5
4 11 7
5 12 9
3 23 15
5 24 23
4 23 23
3 24 11
2 27 30
1 27 12
... ... ...
...
...

[slimdave]

Select
Sum(Decode(WN1,5,1,0)+
Decode(WN2,5,1,0)+
Decode(WN3,5,1,0))
From
TableA;


I'm not clear what you want from the second part.