View Single Post
  #1 (permalink)  
Old 04-03-2008, 05:51 AM
Daniel Kaplan
 
Posts: n/a
Default Stupid MySQL question

Sorry, it's late but am trying to do a count on a table that gives me sum of
search based on user id. In other words

Select sum from Records by userid order by sum.

So that that the results I get back are

userid: 103 7 records
userid: 106 7 records
userid: 105 6 records
userid: 104 5 records
userid: 102 3 records
userid: 101 1 records


I have to tell you, that I'm not stupid, although I have my moments. But am
just really tired and can't figure out the right statement. Any help would
be so appreciated.

Thanks ahead as always.


Reply With Quote