Thread: Help with SQL
View Single Post
  #1  
Old 07-29-2005, 10:20 AM
mistrpug mistrpug is offline
Senior Member
 
Join Date: Jun 2004
Location: ^ my favorite pair
Posts: 271
Default 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.
Reply With Quote