yeah you bet.... lets say the column you want to get the frequency of is called "numusers" and your table is called "mytable".
select numusers count(numusers) from mytable group by numusers that should do the trick On 8/1/05, Roland Dumas <[EMAIL PROTECTED]> wrote: > > If I have the contents of a field in my database as an integer that > could take the values from 1-5 > How do I query the database to tell me the frequency of each integer, > such as: > value - frequency > 1 - 5 > 2 - 0 > 3 - 24 > 4 - 2 > 5 - 1 > > I'm sql retarded. Can someone give me a direction? > ________________________________________________________________________ > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf > ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
