Re: Witango-Talk: [OT] SQL question - getting frequency distribution

[Roland Dumas]

thank you both very much On Aug 1, 2005, at 12:05 PM, Robert Garcia wrote: select value, count(value) as frequency from myTable group by value order by 2 ASC On Aug 1, 2005, at 11:42 AM, Alan Wolfe wrote: 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 ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf