Help with SQL
You have this table:
Col1 Col2 Col3 Col4 Col5
5 26 32 75 84
35 5 45 78 8
65 65 84 26 6
72 26 35 5 84
You have to know how many times each number is returned, and order by the highest returns and then the number itself, getting as the answer:
84 - 3
26 - 3
5 - 3
65 - 2
35 -2
.
.
8 - 1
6 - 1
Help please. Thanks.
|