Jamal Soueidan wrote in post #968670: > Hello, > > I know this might be out of rails question,
Then don't ask it here. > but I could not find any > other place to ask :D Apparently you didn't look very hard: http://lmgtfy.com/?q=mysql+forum > > select count(url_id) as url_count, user_id from urls_users group by > url_id limit 10; > +-----------+---------+ > | url_count | user_id | > +-----------+---------+ > | 238 | 1 | > | 3070 | 2 | > | 141 | 3 | > | 1 | 7 | > | 156 | 8 | > | 397 | 11 | > | 1 | 15 | > | 20 | 16 | > | 73 | 17 | > | 329 | 18 | > +-----------+---------+ > > > How do I get the average url_count on all the users in that table based > on url_id? Read about SQL aggregate functions. Also read about ActiveRecord::Calculations, which abstracts them in Rails. > > Thanks for help. Best, -- Marnen Laibow-Koser http://www.marnen.org [email protected] -- Posted via http://www.ruby-forum.com/. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
